Excel Table Lookup

if your lookup value or table array is formatted as text and the other is not your vlookup will return a na error

the right way of positioning the lookup column vs the return column in a vlookup

in this example we have a table containing both the actual and budget revenues and profits for each application as shown below

horizontal lookup

table excel function excel find value in table excel of the col index element of table excel

index match match example

how to vlookup

lookup table with order details

excel table lookup

clipimage

vlookup example data

clipimage

excel lookup tables lookup tables in excel how to embed a small lookup table in formula excel vlookup table array keeps changing

enter image description here

in this example the second parameter is ab which gives us two columns to data to use in the vertical lookup aa and bb

enter image description here

enter image description here

table excel function excel find value in table excel of the col index element of table excel

excel tips lookup values

array

excel tips lookup values

below is a table comparing the and benefits of each lookup method