I have 2 spreadsheets-one is like this:
I want to copy it into the other and have it compare each item # with the
item# in the existing- AND if there is a match, I’d like it to place the PO#
in the PO column.
Not all items in the 2nd are on the 1st, nor are the items on the 1st in the same order.
I tried some variations with IF and VLOOKUP but am not having luck…
any ideas??