Finding and returning multiple values in colomns across two tabs.

Hey guys I've tried a bunch of different things to make this work more efficiently and I cant figure it out. Basically I need a macro to look for a company I specify then pull the price and the name of the mall associated with it across the two tabs and put it on a new sheet. Any help would be greatly appreciated thanks.

Hi

Where do you specify the company you want?
Where do you expect to find this company?
What do you want to return, from where?
Where are you going to put the output?

How about giving us an example, where the data will come from, why it is selected, and where it has to go.

Also, there seems to be a sheet missing from the example file that the auto_open macro is trying to select.

rylo

Where do you specify the company you want? In a drop down box
Where do you expect to find this company? In column B5:B525
What do you want to return, from where? on a separate sheet I want to return the $ amount and the mall it is associated with.

So for example I want Ann Taylor stores and it would list every Mall and the dollar amount associated with it if its applicable. So in the cutoff worksheet I sent you it would return $333/village point and $366/Promenade Shops.

I dont know whats going on with that auto open macro I cut some stuff off to make the file small enough to upload. Thanks for the help.

Where is the drop down box that you make your selection?
Does the output sheet already exist, or does it have to be created for each selection return?
How do you want the return to be structured? Concatenated, each output in its own cell????

Can you update your example file to show a sample output sheet.

rylo

Updated everything

Hi

So does this mean that for every new selection of an item in 'Tenant Sales Lookup'! E6, you want to have 3 new columns added to the output? Given the results you have don't match the example raw data, I guess that most of them have come from a full set somewhere???

rylo

only 2 columns the mall name and the dollar amount. Ya I had to cut a bunch of stuff off to get it under the 1mb limit. I currently do this using a If statement but it takes forever.