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

On Jan 6, 1:15*pm, KateW wrote:
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

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" wrote:

On Jan 6, 1:15 pm, KateW wrote:
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

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

On Jan 6, 2:05*pm, KateW wrote:
Jay- what does "item" refer to? *

Thanks!
Kate



"jlclyde" wrote:
On Jan 6, 1:15 pm, KateW wrote:
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

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- Hide quoted text -

- 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

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

There are instructions for VLOOKUP he

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

KateW wrote:
Jay- what does "item" refer to?

Thanks!
Kate

"jlclyde" wrote:

On Jan 6, 1:15 pm, KateW wrote:

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

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

--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com

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

On Tue, 6 Jan 2009 12:28:01 -0800, KateW
wrote:

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

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

KateW

"Debra Dalgleish" wrote:

There are instructions for VLOOKUP he

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

KateW wrote:
Jay- what does "item" refer to?

Thanks!
Kate

"jlclyde" wrote:

On Jan 6, 1:15 pm, KateW wrote:

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

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

--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com