This is my third question..I want to run vlookup to do comparison and and get it automated

Hi All,

This time i need to set a macro which i can compare cell in Number in New Order tab and cell B in Status. If it is matching, the result will appear in cell J-New Order tab as "Registered", otherwise is "No"

Attached is the file that i'm referring to

=IF(Status!B2='New Order'!H2,"Registered","No")

Although the formula works just as well.

Please Login or Register  to view this content.

You're welcome. Glad to help out and thanks for the rep.