Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF and VLOOKUP formula
Hi again all:
I have in sheet 1;(Material Costs) A B C 1 Items Seller Price 2 Sand Dropdown List 3 Cement Dropdown List 4 Bars Dropdown List I have in sheet 2;(Sellers) A B C D 1 Items Mick Sam Jim 2 Sand 2$ 3$ 2.5$ 3 Cement 5$ 5.2$ 4.9$ 4 Bars 12$ 10.5$ 11$ Units are same. What formula in sheet 1, can i write that when dropdown list changes the name the exact price of the related seller's name appears in C2:C4 respectively? I tried with IF combination with VLOOKUP which result was #NAME? Thanks for instruction. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP formula | Excel Worksheet Functions | |||
Alternative formula to the vlookup formula? | Excel Worksheet Functions | |||
convert vlookup formula to link formula | Excel Worksheet Functions | |||
Excel 2002 VLOOKUP formula or other formula | Excel Discussion (Misc queries) | |||
Using a Vlookup within an IF formula | Excel Discussion (Misc queries) |