Macro for selecting a value from a dropdown and displaying results

**shilloh** · 06-27-2011, 09:44 AM

Hello

Im not sure how to write a macro for the following

I have two sheets. One of the sheet (Sheet 1)has some values manually entered in a table format. Another sheet (Sheet 2)has a drop down list with a table to get values automatically populated from Sheet 1. Based on each option of the drop down chosen from Sheet2, the corresponding value available in sheet 1 should get displayed in a table in Sheet 2. I have attached the excel .

Appreciate ur help!

Thanks

**tarquinious** · 06-27-2011, 09:55 AM

A simple VLOOKUP will solve this for you (see attached)

**shilloh** · 06-27-2011, 11:01 AM

Hi

Thanks for ur quick response. Yes this helps me, however my actual sheet has a huge table with so many values in it . Finding the column, row corresponding to each value appears to be difficult. Is there any alternate?

I have attached a sample of the table for which i need help.

Thanks for ur help

Shilloh