VLOOKUP

1. SIMPLE VLOOKUP 

The VLOOKUP function performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the ...

Example:

=VLOOKUP(lookup_value,table_array,col_indexnum,[range_lookup])

=VLOOKUP(H6,$D$4:$F$28,2,0)

 

2. VLOOKUP MATCH

Using VLOOKUP MATCH allows you to perform a matrix lookup – instead of just looking up a vertical value, the MATCH portion of the formula turns your column reference into a dynamic horizontal lookup as well.

Example:

=VLOOKUP($S7,$M$4:$Q$23,MATCH(T$4,$M$4:$Q$4,0),0)

3. USE VLOOKUP WITH TEXT TO COLUMN CONDITIONS - Raw Data

Example:

=IFERROR(VLOOKUP(TEXT(AP7,"0"),$AJ$4:$AN$23,2,0),VLOOKUP(AP7,$AJ$4:$AN$23,2,0))

4. USE VLOOKUP WITH TEXT TO COLUMN CONDITIONS - Out Put Data

Example:

=VLOOKUP(VALUE(BB6),$AV$4:$AZ$23,2,0)

5. DOUBLE VLOOKUP - Data Pic From Two Sheets or Two Raw Data

Example:

=IFERROR(VLOOKUP(BK7,$BG$4:$BI$28,3,0),VLOOKUP(BK7,$BH$4:$BI$28,2,0))