Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple "lookup_value"
Pls help me how to write a formula on multiple lookup_value".
=LOOKUP(lookup_value,lookup_vector,result_vector]) My question is based in the lookup_value. Is it possible that i can have multiple lookup_value? Fruit Size Weight Price Apple m 1 0.1 Apple s 2 0.2 Grape l 3 0.2 Banana s 1 0.25 Pear m 2 0.35 Apple m 2 0.1 I like to look for the "Price" of apple(fruit) that is M(size), 1 (weight) from the table above. How do I do it? I need an exact match for the lookup_value i tried a combination of lookup and concatenate formulas but is not working. Please help me. Thanks a lot! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Combining formulas, "and" & "or" to verify content of multiple cel | Excel Discussion (Misc queries) | |||
"Control" plus "click" doesn't allow me to select multiple cells | New Users to Excel | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
freeze window creates multiple "views" suffixed with ":n" | Excel Discussion (Misc queries) |