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??
Hallo
K2:
=IFERROR(INDEX(othersheet.$C$2:$C$1000;MATCH(A2;othersheet.$D$2:$D$1000;0));"")
#replace »othersheet« with the real name of the other SheetThanks for responding… but it doesn’t seem to do what I was after.
I am attaching my spreadsheet.
I pasted my other “sheet” in columns T-W.
I want to compare the list of items column A with list of items in Column U, AND
if there is NOT a match- leave Column I blank…if they DO have a match somewhere in Column U, I want the contents of Column T (of the matching row) to appear in Column I of the Row that has the match in Column A…
I would also like to get the Qty (Column W) to populate Column J in the same fashion…
Thanks for any suggestion or assistance. (I2 has my modified formula)
GLBC Master - POs and Qty.ods (87.5 KB)
You are the bomb…Much appreciated!!!
Sorry to bother you…but each week I get new information for those columns T thru W.
When I pasted that info into the spreadsheet- it did not update Columns J & K…
any insight on that?
did you unset ⇒Data⇒Calculate⇒ [x]AutoCalculate ??
Autocalculate is still set…I am going to try pasting one column at a time into T U V W
GLBC Open PO as of 12.05.2025.xls (40.5 KB)
GLBC Master - POs and Qty.ods (98.8 KB)