Formulas

[rsl_ceo]

I have multiple worksheets that have information listed like as follows:

Column A

AB1020
KH1018
KH1013
MM1021
AB1020
KH1018
KH1013
MM1021
AB1020
KH1018
KH1013
MM1021

Now on another worksheet I have a list of these items and their costs:

AB1020 1.57
KH1018 2.07
KH1013 2.67
MM1021 3.17

I want to create a formula that will see the value in column A on sheet 1,
find the match in column A on sheet 2 and input the data located from column
b of sheet 2 in column b on sheet 1.

[Anne Troy]

Hi, RSL. You'll want to do something very much like this sample file:
http://www.myexpertsonline.com/freedls/pricelist.xls
And here's the features you need to accomplish it:
Dropdowns:
http://www.officearticles.com/excel/...soft_excel.htm
Vlookup:
http://www.officearticles.com/excel/...soft_excel.htm

Hope it helps!
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com



"rsl_ceo" <rsl_ceo@discussions.microsoft.com> wrote in message
news:EA95C5A3-B496-42A7-AB1E-CEB8007ABDE3@microsoft.com...
> I have multiple worksheets that have information listed like as follows:
>
> Column A
>
> AB1020
> KH1018
> KH1013
> MM1021
> AB1020
> KH1018
> KH1013
> MM1021
> AB1020
> KH1018
> KH1013
> MM1021
>
> Now on another worksheet I have a list of these items and their costs:
>
> AB1020 1.57
> KH1018 2.07
> KH1013 2.67
> MM1021 3.17
>
> I want to create a formula that will see the value in column A on sheet 1,
> find the match in column A on sheet 2 and input the data located from
column
> b of sheet 2 in column b on sheet 1.
>
>
>