One way for multi-condition lookup is to use index/match (array-entered),
something along these lines ..
Put in the formula bar for H1, then array-enter the formula
by pressing CTRL+SHIFT+ENTER (instead of just pressing ENTER):
=INDEX(A1:A100,MATCH(1,(A1:A100=1)*(D1:D100=9),0))
Adjust the ranges to suit (note that entire col references cannot be used)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Little Penny" wrote in message
...
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