What is the easiest way to bring up data in adjacent cell after s.

[Jason]

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?

 

[Arvi Laanemets]

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(LookupTable!$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