Scribd
Upload
6 views2 pages

VLOOKUP Examples and Formulas in Excel

Uploaded by

jainflamingo
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
6 views2 pages

VLOOKUP Examples and Formulas in Excel

Uploaded by

jainflamingo
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

ID Name Department Salary Grade

101 John HR 50000 B


102 Mary Finance 60000 A
103 Sam IT 55000 B
104 Joseph Marketing 65000 A
105 Anita HR 70000 A
Type FormulaExplanation
Exact Matc #N/A Returns Department for ID 101
Approxima #N/A Returns nearest Grade for Score 76
With Wildc #N/A Finds names starting with Jo
Named Ran #NAME? Salary for ID 105 using named range
Two-Way L #N/A Finds salary dynamically
With IFER Not FoundAvoids error if not found
Across She #NAME? Looks into Sheet2
Multiple Cr #N/A Lookup with 2 conditions
Left Looku #N/A Looks left using CHOOSE
Nested VL #N/A Lookup inside another lookup
Date Range #N/A Finds today’s date in a range

You might also like