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?