Drop down list - need to reference and populate another cell with

[KateW]

I have a drop-down list in one column on my "cover" sheet that pulls from a
named range on another sheet. I want the user to be able to choose an item
from the drop-down list and then in most cases have the correct amount for
that fee code/description populate into the next column. Is there a
formula/etc I can use to do this? I'm stumped.

Thanks!
KateW

 

[jlclyde]

I have a drop-down list in one column on my "cover" sheet that pulls froma
named range on another sheet.  I want the user to be able to choose an item
from the drop-down list and then in most cases have the correct amount for
that fee code/description populate into the next column.  Is there a
formula/etc I can use to do this?  I'm stumped.  

Thanks!
KateW

Could you not use Vlookup? Create a table next to your named range
with prices. Then you could do Vlookup("Item",Lookuprange,Column to
look at, False)

Jay

 

[KateW]

Jay- what does "item" refer to?

Thanks!
Kate

Could you not use Vlookup? Create a table next to your named range
with prices. Then you could do Vlookup("Item",Lookuprange,Column to
look at, False)

Jay

 

[jlclyde]

Jay- what does "item" refer to?  

Thanks!
Kate







- Show quoted text -

You used the word item to say what the person had selected. I was
using it to show how it would be used in your context.
Jay

 

[KateW]

Sorry to be dumb, Jay but I'm still confused and can't get it to work.

I can't put in the exact string since it will be a drop down choice so I put
in the cell reference in quote and not in quote and neither worked - I keep
getting a #NAME? error referring to that part of the formula.

=VLOOKUP(C4,H4:I100,I,FALSE)

=VLOOKUP("C4",H4:I100,I,FALSE)

Also, there's the issue that I don't want to enter the result from the cost
column every time.

Any other suggestions?

Thanks for your time.

KateW

 

[Debra Dalgleish]

There are instructions for VLOOKUP here:

http://www.contextures.com/xlFunctions02.html

and a sample order form here that fill in adjacent cells when a product
is selected:

http://www.contextures.com/xlOrderForm01.html

 

[Gord Dibben]

VLOOKUP table requires at least two columns, which you have, but you have to
change the column index number in your formula.

=VLOOKUP(C4,H4:I100,2,FALSE)

I would also "fix" the table range so's it won't change as you copy down.

=VLOOKUP(C4,$H$4:$I$100,2,FALSE)


Gord Dibben MS Excel MVP

 

[KateW]

Thanks everyone for your help - my spreadsheet is coming along nicely now.

KateW