Forum Discussion
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...
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?
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.