Thanks, Myrna! I had considered that but I'd like the value the user is
choosing initially to come from a validated list. Can I use a validated list
in a VLOOKUP formula?

~cr

"Myrna Larson" wrote:

Check out the VLOOKUP function in Help. You can use a named range for your
list/table, and if you insert new rows within it (rather than tacking stuff on
at the end), the definition of the name will update automatically.

On Wed, 5 Oct 2005 11:42:03 -0700, cindee
wrote:

FYI - I know I could use a series of Nested IF statements but I'd like to be
able to add to my list fairly easily.

Thanks in advance!!!

~cindee

"cindee" wrote:

I would like to put a short name like "BILL" in column C and have it return
a
whole block of preentered text about Billing. I need a validated Lookup
where I choose the "short name" and the text is returned from somewhere
hidden on the sheet.

I think I need to determine what shows in a cell based on the value in an
adjacent cell. Any ideas?

Thanks

Cindee