Help in excel. I have a master sheet of part numbers and prices. ?

I need to create a lot of other worksheets for individual machines that list each part number that is on that machine, along with the price. Is there anyway to get the worksheet to read the price off the master sheet without having to retype all the prices? Each machine has a different variety of parts so I've been having trouble trying to figure out how it can only pull certain prices for certain parts off the master sheet. Help in excel. I have a master sheet of part numbers and prices. ?
Yes, just use the vlookup formula


let's say in your master sheet you have Part # and Price in A1 %26amp; B1


and more below it (A2/B2, A3/B3, etc down to A100/B100)





we'll call this sheet ';Master';


in another sheet in Cell A1 you have a part # entered. And you want to view the price in B1 from the Master sheet. In B1 enter





=VLOOKUP(A1, MASTER!$A$1:$B$100, 2, FALSE)


this will look up A1 and try to find a match in your master sheet. If there's a match, it will return the info from the 2nd column (the price).





the ';false'; at the end just tells excel to find an exact match. If no match is found you'll get an error value instead.





the basic syntax of the vlookup is


VLOOKUP(criteria you want to find, where you want to find it, column of data you want returned).





the $ signs in the range $A$1, etc just tell excel not to change those cell references (ie lock them down) as you copy/paste the formula.





have fun... :-))))