Report

Vlook up [Solved]

Ask a question Sri - Last answered on Jun 6, 2017 at 07:14 AM by 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
Helpful
+0
plus moins
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
Leave a comment
Helpful
+0
plus moins
Thank you very much.It worked :)
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!