I am trying to find the syntax for determining if a field on my current worksheet matches a field on another worksheet. Note, there are over 12000 records to check.
I can currently designate a field on the current worksheet, then do a =IF(iserror(Vlookup))), followed by a copy and paste special, selecting value, then create a variable from that value, but there has to be a simpler way.
I can currently designate a field on the current worksheet, then do a =IF(iserror(Vlookup))), followed by a copy and paste special, selecting value, then create a variable from that value, but there has to be a simpler way.