Automatically change list values

  • Thread starter Thread starter DKerr
  • Start date Start date
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
 
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
 
Back
Top