Vlook up [Solved/Closed]

Sri - Jun 6, 2017 at 02:45 AM - Latest reply:  Sri
- Jun 6, 2017 at 07:14 AM
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
See more 

2 replies

Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - Jun 6, 2017 at 06:21 AM
0
Thank you
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
0
Thank you
Thank you very much.It worked :)