Vlookup

L

Little Penny

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
 
J

JMB

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))
 
Top