I am sorry I must be doing something wrong. I have a
worksheet named "Small quote sheet" (has apx 900 rows) in
that worksheet I have specific part numbers starting with
A1 and going down column A, B1 is open. I have another
worksheet named "Master list w-cost" (has apx 6200 rows).
The part numbers also start in A1 and run down column A
with the price starting in B1 and running down column B.
I want to pull the price from the Master list and drop
the correct price into the smaller list. Please
help...Thank you
-----Original Message-----
Take a look at VLOOKUP in the help part of the function
icon, ie click on the function wizard,
select the VLOOKUP function and then hit help in the
dialog box and you will get an example.
With your part number on your smaller sheet in A1, in cell B1 put
=VLOOKUP(A1,'Sheet 1'!$A$1:$B$100,2,0)
which will look up the value in A1 in the large list on
sheet 1 in the range A1:B100 (Assumes
part numbers in Col A on sheet 1 and prices in B), and
then give the corresponding value on the
same row from the 2nd column in that table, ie Col B.
The 0 is important as it forces an exact
match, as there are times when close enough will do.
Then just copy cell B1 on your smaller sheet and paste
down as far as you need in Col B
If you have problems then post back with exact ranges
and file/sheet names and we can give you the
