Previous Topic Next Topic

VBA 2007 - Colum Comparison VLOOKUP

Closed
tixilee Posts 3 Registration date Tuesday August 28, 2012 Status Member Last seen September 6, 2012 - Sep 6, 2012 at 10:35 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Sep 15, 2012 at 07:15 AM
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 :-)
Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Sep 15, 2012 at 07:15 AM
for that you need to use match


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

Similar discussions

Create folder in desktop with vba, if exist, ignore
viriato74 -
praveen -

6 responses