Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup
Is it possible to use vlookup to return a value if a second cell meets
a certain condition? For example A1 -1 B2-2 C3-3 D4-4 H1-? A2- 1 B2-7 C2-8 D2-9 I want to vlookup the number 1 in column A and return the value in column cell H1 where column D has a value of 9 In this case it would return the number 9 Or is the some other way to do this Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup isn't working correctly? | Excel Discussion (Misc queries) | |||
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 |