Vlook up [Solved/Closed]

Report
-
 Sri -
Hello,

I have 2 columns A & B in sheet1 and i want to Return Yes if either A or B value mactches with Coulmn A in Sheet 2.

Please help

3 replies

Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
131
Sri, Good morning.

Try to use:

=IF(OR(ISNUMBER(MATCH(A1,Sheet2!A1:A5,0)),ISNUMBER(MATCH(B1,Sheet2!A1:A5,0))),"Yes","")

Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Thank you very much.It worked :)