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

  • Thread starter Thread starter KateW
  • Start date Start date
K

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
 
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
Click to expand...

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
 
Jay- what does "item" refer to?

Thanks!
Kate

jlclyde said:
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
Click to expand...
 
Jay- what does "item" refer to?  

Thanks!
Kate







- Show quoted text -
Click to expand...

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
 
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
 
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
 
Back
Top