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.
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.