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

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

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

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

You can certainly use Data/Validation to limit what the user can type in the
cell. Presumably the VLOOKUP formula is in a cell other than the one used for
data entry.

On Wed, 5 Oct 2005 12:01:09 -0700, cindee
wrote:

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

ahhh, use the Validated List in one column and then do a VLOOKUP in the
adjacent column! Now I've got it! Thanks, Myrna!

~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