How to use lookup command

**hwtcrl** · 06-09-2011, 07:26 PM

I've searched the internet for what I need, and can't seem to understand what I'm missing. So, in general I have a main sheet created which is form to be filled out by the user. I have a drop list created using the data validation tool, with the list choices coming from another worksheet in the same excel file...these choices are grouped together for the drop down list. The next part is confusing me looking at examples. I need this drop down list, lets say its in cell C10, to automatically populate another cell (cell M10) on the main form sheet when the user selects a choice in this drop down. I need cell M10 populated with information from another sheet in the same document. I'm aware of the lookup command, but can't figure it out. Can someone dumb it down and explain what and where I should be entering commands to make this work? I hope this isn't too confusing to understand. Any help is greatly appreciated!!

**teylyn** · 06-09-2011, 07:31 PM

Please upload a sample workbook that shows your data layout. It's impossible to suggest a formula without knowing where your data is.

**hwtcrl** · 06-09-2011, 07:45 PM

Section 8 "title" is the drop down menu, that when selected I want to populate section 9 from sheet JPR Coverage, hope this helps.

**teylyn** · 06-09-2011, 07:52 PM

Can you give an example of what the expected result in "Section 9" will be? I assume thr huge merged cell in M10 is what you call "Section 9". I fail to see how the value "March RT 2011" can be used to lookup any data on the JPR sheet. What's the connection?

**hwtcrl** · 06-09-2011, 07:55 PM

When the user selects for example "March," M10 should be populated with column A's list of items in sheet JPR.

**teylyn** · 06-09-2011, 07:56 PM

Or, do you mean the data on the SCRIPT sheet? If so, the formula in M10 needs to be

=VLOOKUP(G10,SCRIPT!$A$1:$B$18,2,FALSE)

cheers,

**teylyn** · 06-09-2011, 07:57 PM

When the user selects for example "March," M10 should be populated with column A's list of items in sheet JPR.

you cannot return the values of multiple cells in one cell.

**hwtcrl** · 06-09-2011, 07:58 PM

I understand that my layout is probably not the best solution for getting data into certain cells, but this is made to be simplified for fellow workers to be able to update information who are not excel whiz kids.