G
Guest
I have a Sales table and a Product table. If the item #(column C) in the
Sales table does not match an item #(column A) in the Product table:
1) I do not want it written to a Match table(column A), if true, I do.
2) I want the next match to be directly below the last match.
I've tried variations of ISERROR(VLOOKUP)... and ISNA - but just don't know
enough to get it right!
TIA,
Carole O
Sales table does not match an item #(column A) in the Product table:
1) I do not want it written to a Match table(column A), if true, I do.
2) I want the next match to be directly below the last match.
I've tried variations of ISERROR(VLOOKUP)... and ISNA - but just don't know
enough to get it right!
TIA,
Carole O