Exporting data using Pulldown List & VLOOKUP

[San]

Hi Friends,

I am developing a portfolio tracker excel file. I am having some difficulty
in implementing one function, which I think I cannot create using macro.

I am downloading various parameters using the SMF Add-In. Which is working
fine. After downloading these data I want to export them into the other sheet
"Pull Down Option". I tried to use OFFSET and VLOOKUP function. But it is not
working. In the Pull Down Option sheet, I have created a droop down list, so
when I change the droop down list, the data associated (Sheet Data) with it &
a stock symbol should change.

Regards,

 

[Bob Bridges]

You say it's not working, San, but you don't say what you did and HOW it's
not working.