Hi, it's working, but not from a range.
Can you make something like this?
=VLOOKUP(A1, sheet1!A1:B251, 3, FALSE);(A1, sheet1!A1:B251, 2, FALSE)
If A1 is empty, the code to look in B1.
The code in A1 to retrieve data from cell 3 and if A1 is empty to look in B1
and to retrieve data from cell 2.
Thanks in advance!
"Francis" wrote:
try this formula
=IF(OR(A1=Sheet2!A1,B1=Sheet2!B1),Sheet2!C1,"")
--
Hope this is helpful
Pls click the Yes button below if this post provide answer you have asked
Thank You
cheers, francis
Am not a greek but an ordinary user trying to assist another
"puiuluipui" wrote:
Hi Don, i even searched on google, but i can make it wright.
=if(or(A1=Sheet2!A1:C3,B1=Sheet2!A1:C3,3,)
This what i've got so far, but it really seems so far!
Ofcourse it give's me an error!
I don't know so much excel or english to completly understand what i have to
do.
Can you push me a little forward with this formula?
Thanks allot!
"Don Guillett" wrote:
Look in the help index for
OR
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"puiuluipui" wrote in message
...
Hi, i need a formula that retrieve data if one of two criteria is met. I
need
the formula in "C".
If A1 or B1=Sheet2!A1:D25,retrieve content of cell 3
Ex:
Sheet 2:
A B C
John 32 AP
Mary 28 TRP
Jim 38 AP
Sheet 1
A B C
John =AP
28 =TRP
Jim 38 =AP
If one of two criteria is met, or if both criteria is met.
Can this be done?
Thanks!