Thread
:
one of two criteria
View Single Post
#
8
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
one of two criteria
I'm still having a problem understanding what you want.
Send your workbook to my address below along with an explanation and
before/after examples.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"puiuluipui" wrote in message
...
Hi Don, it's not working. it retrieve data but it doesn't matter if in A1
is
only a letter (k), or in B1 a only a number(9).
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!
"Don Guillett" wrote:
If I understand, one way
=IF(OR(COUNTIF(Sheet2!$A$1:$C$3,A1),COUNTIF(Sheet2 !$A$1:$C$3,B1)),c1,"")
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Francis" <xlsmate(AT)gmail(DOT)com wrote in message
...
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!
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett