Need help with VLOOKUP
The lookup column should be the first column in your range. Also you
probably want to set the last parameter to false so it looks for the exact
ingredient. Try:
=VLOOKUP(E6,'Food DataBase'!E1:H2500,4,FALSE)
-Simon
"sfi" wrote:
Have two worksheets
1st worksheet is called "Food Database"
A B C D E F G
H
Blank Item# Brand Pack Ingredients Pricing Units oz/ea. Cost Per oz/ea
2nd worksheet is called "Recipe Calculation"
A B C D E F G H I
J
Blank Blank Blank Blank Ingredient Blank Blank Qty Unit Unit Cost
Have formula =VLOOKUP(E6,'Food DataBase'!A1:H2500,8,TRUE) in "Recipe
Calculation" J(Unit Cost)
E6 is the first ingredient listed in Recipe Calculation that I want it to
lookup
Want it to lookup Recipe Calculation E(Ingredient) and return the value in
Food DataBase H(Cost per Oz/ea)
to Recipe Calculation J(Unit Cost)
Currently it returns a 0
It should return $ 0.17
What did I do wrong
Thanks
DuWayne
|