VBA 2007 - Colum Comparison VLOOKUP

[Closed]
Report
Posts
3
Registration date
Tuesday August 28, 2012
Status
Member
Last seen
September 6, 2012
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

Could you please help me?

In worksheet 1, column POOL, there is a code.
In worksheet 2, column MOON, there is a code.

I would like that
If the code on each row of column POOL is found in column MOON,
write down the matching row in column MOON,
otherwise tag the message "NOK".

Thanks :-)

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
for that you need to use match


=IF(ISERROR(MATCH(c1,SHEET1!A:A,0)),"NOK",MATCH(c1,SHEET1!A:A,0))