Forum Discussion

Copper Contributor

Aug 20, 2023

Data?

I am trying to take data from one page to another page. I am trying to take a part number on one sheet and have that to another along with its prices so that I can use an excel sheet type part number...

Excel for web

HansVogelaar

MVP

Aug 20, 2023

Tim_Parkinson393

Let's say you have a sheet PriceList with part numbers in A2:A50 and the corresponding prices in B2:B50.

On another sheet, you enter a part number in D2 and down (or select it from a drop-down list).

Enter the following formula in E2, then fill down.

If you have Microsoft 365 or Office 2021:

=XLOOKUP(D2, PriceList!$A$2:$A$50, PriceList!$B$2:$B$50, "")

If you have an older version:

=IFERROR(VLOOKUP(D2, PriceList!$A$2:$B$50, 2, FALSE), "")

Tim_Parkinson393

Copper Contributor

Aug 20, 2023

Thanks for understanding what I am trying to do. I am using Microsoft 365. I tried to select the “price list” columns to add to the formula was successfull there, but do I need the $ in all those spots? Also at the end of the formula there is “” what is that function?

HansVogelaar
MVP
Aug 20, 2023
Tim_Parkinson393

The $ signs make the reference to the ranges on the PriceList sheet absolute, i.e. they won't change when you fill or copy the cell with the formula downwards.

See Switch between relative, absolute, and mixed references

The "" at the end makes the formula return a blank (empty string) if you enter a non-existent part code.