excel

[safwen]

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.

[#2 · Accepted 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.

[#3]

@Hans Vogelaar 

it didn't work

[#4]

@safwen 

Which version of Excel do you have?

[#5]

365

[#6]

thanks sir it's working

[#7]

@safwen 

Great, thanks for the feedback.