J
John
I need to write a macro which will perform a different
instruction set if a duplicate is found in a table vs.
where there's no duplicate. The instruction VLOOKUP
(X1,Table!A1:Table!E30,1,FALSE) returns a value of #N/A if
no match is found. How can I populate a cell with a value
I can use in my macro to determine if there's a match or
not?
Thanks in advance.
instruction set if a duplicate is found in a table vs.
where there's no duplicate. The instruction VLOOKUP
(X1,Table!A1:Table!E30,1,FALSE) returns a value of #N/A if
no match is found. How can I populate a cell with a value
I can use in my macro to determine if there's a match or
not?
Thanks in advance.