VLOOKUP function

Excel » Functions » Lookup and reference » VLOOKUP function »

How to use the VLOOKUP function




How to use VLOOKUP with multiple conditions

I will in this article demonstrate how to use the VLOOKUP function with multiple conditions. The function was not built […]

Return multiple values if in range

The image above shows a formula in cell C11 that extracts values from column D if the number in cell […]

How to return a value if lookup value is in a range


VLOOKUP of three columns to pull a single record

Question: Does anyone know how to do a VLOOKUP of three columns to pull a single record? Answer: Array formula in […]

Choose between two data sets to VLOOKUP

Question: How do I search a specific data set, I have two tables to choose from? Answer: Formula in cell C13: […]