Oct 23 2023 12:43 AM
You can use VLOOKUP or XLOOKUP for this.
Let's say you have a sheet Price List with SKUs in A2:A100 and prices in B2:B100.
On another sheet, you enter the SKU of a product in D2.
In E2:
=IFERROR(VLOOKUP(D2, 'Price List'!$A$2:$B$100, 2, FALSE), "")
or
=XLOOKUP(D2, 'Price List'!$A$2:$A$100, 'Price List'!$B$2:$B$100, "")
This can be filled down.