ExcelBanter - index help

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - index help (https://www.excelbanter.com/excel-discussion-misc-queries/212252-index-help.html)

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?

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
---
"Jane Griffel" wrote:
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?