read data

Copper Contributor

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), "")


=XLOOKUP(D2, 'Price List'!$A$2:$A$100, 'Price List'!$B$2:$B$100, "")

This can be filled down.