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