index help

[Jane Griffel]

I have an information sheet that has a pull down list using L6:L35 and
information in cloumn M that associates to it. I want information from column
L to go into a cell in which allows the another cell in the information sheet
to auto populate with the infomation in M. How do I write the formula for
this to happen?

 

[Max]

Assume the DVs are in A2 down
In B2: =IF(A2="","",VLOOKUP(A2,$L$6:$M$35,2,0))
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik