Automatically change list values

D

DKerr

Hi,

I would like to alter a spreadsheet so that the list values in B1 fo
instance would change depending one of two options placed in A1. Th
two columns containing the list info would be in column g1 to g20 an
f1 to f20. thanks for any assistance
 
D

dcronje

In B1 use this formula:

=vlookup(A1,$F$1:$G$20,2)

This assumes lookup value is in column F and value to be returned i
column G

Hope this helps
 
Top