Vlook up
Solved/Closed2 responses
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
6 Jun 2017 à 06:21
6 Jun 2017 à 06:21
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
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
