SOLVED

excel

Contributor

Hey guys 
please I want to get this result any ideas ? I want to add the price to the original table from other sheet in same excel file.

safwen_0-1665131619269.png

 

6 Replies
best response confirmed by safwen (Contributor)
Solution

@safwen 

Let's say the price list is on a sheet named Price List in A1:C4.

In D2 om the other sheet, if you have Microsoft 365 or Office 2021:

=XLOOKUP(A2, 'Price List'!$A$2:$A$4, 'Price List'!$C$2:$C$4, "")

If you have an older version:

=IFERROR(VLOOKUP(A2, 'Price List'!$A$2:$C$4, 3, FALSE), "")

Fill down.

@Hans Vogelaar 

safwen_0-1665134690945.png

it didn't work

 

@safwen 

Which version of Excel do you have?

365
thanks sir it's working

@safwen 

Great, thanks for the feedback.