Vlook up

Solved/Closed
Sri - Updated on Jun 6, 2017 at 03:36 PM
 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

2 replies

Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
147
Jun 6, 2017 at 06:21 AM
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 very much.It worked :)
0