Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with VLOOKUP
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup a Vlookup | Excel Worksheet Functions | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |