Hi

VLOOKUP function.
An example:

You have a sheet LookupTable, with columns:
ListValue, Response1, Response2, ...

You have 2 named ranges defined p.e. as:
List=OFFSET(LookupTable!$A$2,,,COUNTIF(LookupTable !$A:$A,"<")-1,1)
LookupTable=OFFSET(LookupTable!$A$2,,,COUNTIF(Look upTable!$A:$A,"<")-1,N)
where N is the number of columns in lookup table.

On some another sheet, you have data validation list in some cell, p.e. A1,
with source:
=List
Into any (adjacent) cell, to retrieve p.e. responding value of Response2,
enter the formula:
=VLOOKUP(A1,LookupTable,3,0)


Arvi Laanemets


"Jason" wrote in message
...
I am trying to get another cell to fill in based on the seletion from a
drop-down list. What is the cleanest way of doing this?