Combining drop downs

[ronw55]

I have two drops downs; one in A1 (item) and one in B1 (lbs). Lets say I have a list of items A thru E in cells A11:A15 and adjacent to them are the actual weight values of lets say 1 thru 5 lbs in cells B11:B15. Can I combine the information into one drop down that will display in two adjacent cells? For instance if I select item 'C' in the drop down A1 can I also get the corresponding weight of '3' lbs to display in cell B1?

 

[ArthriticPanda]

try this...

Excel Workbook
	A	B
1	Item3	3 lbs
2
3
4
5
6
7
8
9
10
11	Item1	1 lb
12	Item2	2 lbs
13	Item3	3 lbs
14	Item4	4 lbs
15	Item5	5 lbs
Sheet1

#VALUE!

AP

 

[ArthriticPanda]

...the named range, rng_weight is the range B11:B15

AP

 

[ParamRay]

Either of these formulas will work in cell B1:

=INDEX(B11:B15,MATCH(A1,A11:A15,0),1)

=VLOOKUP(A1,A11:B15,2,FALSE)

 

[ronw55]

ArthriticPanda,
Thank you very much. That works exactly as I wanted.
Ronw55

 

[ronw55]

gpeacock,
Thank you very much too. Both of these worked as well. All I had to do was transpose the cell numbers for my actual spreadsheet and it worked!
Ronw55