Forum Discussion
read data
Hello, i need help to read the price on a column, then in another sheet, ceck the sku of the product and write the price wrote in the other sheet.
1 Reply
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.
