drop down data entry

R

Rich

Greetings,

I couldn't find what I was looking for on contextures so I thought I'd
submit it here.

I have a small spreadsheet that does a very basic calculation. In this
spreadsheet I have a 2 column list. Column 1 has the name of the item and
column 2 carries its value. (A1 = Item 1, B1 = 500)

I've created a dropdown list from column 1 and would like the value for the
item selected from column 2 to be entered into a different cell.

I think I've done this in the past using VLOOKUP but I can't figure out how
I did it. Can someone please give me a clue?

TIA
Rich
 
R

Roger Govier

Hi Rich

It depends where the source data is located. Let's assume it is columns
A and B of sheet2.
In B1 on sheet1 enter
=VLOOKUP(Sheet2!A:B,2,0)
 
R

Rich

Thanks much for your response. The data is in columns G7:G76 and H7:H76 on
the same sheet.

The dropdown list refers to G7:G76 and is located at D2.

I would like D4 to contain the value called for in H7:H76.

In your formula I obviously understand what Sheet2! is but have no clue what
the other values are.

When I put the formula =VLOOKUP(G:H,2,0) into D4 I just get the #VALUE!
error. (don't laugh, I'm a noob at this).

Rich
 
Top