Help plez.... not sure how to explain

[Otie]

Ok..... this is what is going on i am still learning excel. i have
worksheet that has rows of part #'s ... beside the part #'s is th
section that it is in..... for example

1111111 l SP0110 l Price001
2222222 l SP0110 l Price001
3333333 l SP0110 l Price001
4444444 l SP4444 l Price002
5555555 l SP4444 l Price002

how could i be able to add a Price value to all the sections of th
same kin

 

[mzehr]

Hi,
Put your prices in a table say in Sheet2!A1:B5
Then you can use the following formula in E1 and copy down:
=VLOOKUP(C1,Sheet2!$A$1:$B$5,2,FALSE)
For more help on vlookups see:
http://www.cpearson.com/excel/lookups.htm

 

[AlfD]

Hi!

I would use a lookup table.
To make the lookup table, choose an empty space on the worksheet wher
you will not accidentally delete rows, columns or cells.
Now fill it in:

First column: Section numbers
Second column: corresponding prices for these Sections.

Call this table PriceTable, for example. Do this by highlighting th
lookup table, then use Insert > Name > Define. The box "Refers to
should show the range for your lookup table. Type the name for it i
the text box at the top and click OK.

I will assume that your original table is in columns A,B C and row
is headings.

Then in the price column, C, of your original table put in row 2
=vlookup(B2,PriceTable,2,False). Copy this formula down as many rows a
you need.

If you have trouble with #N/A showing as the result, that will b
because you are trying to look up a value which is not in the table.

Come back if you need more help. Also read about Vlookup in Help.

P.S. We are _all_ still learning Excel.

Al