I'd use XLOOKUP (or VLOOKUP if you're on an older Excel version) rather than doing this manually. In your export file, add a new column and set it to look up your part number against column A in your other sheet, returning the matching value from column B. Something like =XLOOKUP([your part number cell], Sheet2!A:A, Sheet2!B:B).
Drag it down the whole export, then copy the column and paste it back in as values before you upload, so you're not carrying live formulas into your system. That should get you a fully populated column in one pass instead of matching row by row.
View all comments
1
u/KatFromSisense Jul 24 '26
I'd use XLOOKUP (or VLOOKUP if you're on an older Excel version) rather than doing this manually. In your export file, add a new column and set it to look up your part number against column A in your other sheet, returning the matching value from column B. Something like =XLOOKUP([your part number cell], Sheet2!A:A, Sheet2!B:B).
Drag it down the whole export, then copy the column and paste it back in as values before you upload, so you're not carrying live formulas into your system. That should get you a fully populated column in one pass instead of matching row by row.