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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup
Assuming your data is in a1:h100, try
=INDEX(H1:H100, MATCH(1&" "&9, A1:A100&" "&D1:D100,0)) array entered w/Cntrl+Shift+Enter. You could set your criteria up as a reference I1 =1 J1 = 9 =INDEX(H1:H100, MATCH(I1&" "&J1, A1:A100&" "&D1:D100,0)) "Little Penny" wrote: 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 |
Reply |
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 |