PDA

View Full Version : Solved: Get multiple cells as a result in a dropdown list



Raf
12-21-2008, 10:50 AM
Hi there,

I would like to make a dropdown list where it's possible to get more then one cell as a result.
If cells a1-a10 are the source of the list, I would also like to get cells b1-b10 and c1-c10 as a result
So if I pick cell a3 from the dropdown, I will get cells a3, b3 and c3 as a result...

Raf.

lucas
12-21-2008, 12:12 PM
Hi Raf, welcome to the forum. Sounds like you need to check into the vlookup function in excel.

If you go to this link there is an excellent explaination and example file to download to get you started:
http://www.excel-it.com/excel_functions.htm

It is the second function on the page......vlookup


If you have trouble understanding it or implementing it you can post your questions back here.

Raf
12-22-2008, 01:55 AM
Thanks, just what I need!

lucas
12-22-2008, 12:08 PM
Hi Raf, When you get this working and have no questions left would you mind marking your thread solved using the thread tools at the top of the page?

Raf
12-23-2008, 02:28 AM
Oh, yes, almost forgot that! Thanks.