excel with indirect matching across worksheets

[ccb95x]

I am a relative newbie so please be kind.

I am having trouble trying to get the formula correct to retrieve the market sales for Mrs Renfros salsa from the worksheet called Albany. I want it to be placed in cell C6 in the Master worksheet.

I was able to corretcly use the indirect function to pull the total regional dollar sales, but am having trouble combining it with the match function so that it find the appropriate row to retrieve the data from Column 6.

Please help - work related and I need to get it done soon!!

[6StringJazzer]

Welcome to the Forum!

I am sorry to be so blunt but for a situation like this screenshots are useless. We can't see your formulas, nor can we work with your workbook to provide corrections. And actually, I can't even see what is wrong. Looks OK to me

It is actually far more trouble to capture a screenshot, save it to disk, and then upload it then it would be to upload your actual Excel file.

This looks like business data so it may be too sensitive to post. If so you can tweak it to disguise it (like in column A replace the brand names with

="BRAND"&ROW()

and replace dollar amounts with

=RANDBETWEEN(1000,9000)

Something like that.

At a bare minimum you have to tell us what cell you need a formula for and describe in English the business rule for how to get a result.

[ccb95x]

Great point. I masked everything that I really need to.

Ultimately I need to be able to populate the data in the Master worksheet by pulling it from the subsequent worksheets.

I think once I get the format I can takje it from there.

So, for instance, I need to populate the cell C6 on the Master worksheet with the data from cell E29 (the highlighted row). The caveat is that I need it to find the row by searching for it (with a match function I think - something like MATCH"MY*" ?

There are 4-5 differenct columns that I will need to be able to do this for.

Thanks for your quick reply and help!

[6StringJazzer]

We're getting closer, but if I look at your Master sheet, I can't figure out what criteria you have to be able to find row 29 in Albany. Are you always looking for "MyBrand" no matter what? If so, you can use

=VLOOKUP("MyBrand",INDIRECT($A6&"!A:E"),5,FALSE)

I am not sure I have interpreted your question correctly, though. If you need to look for different brands, depending on the situation, then I need to understand how you would want that to work.

[ccb95x]

This worked perfectly thank you so much!!

I am always looking for the same brand.

And if I want to have it pull the data from the same brand, but a different column do I just change the 5 to denote the number of the column?

[6StringJazzer]

And if I want to have it pull the data from the same brand, but a different column do I just change the 5 to denote the number of the column?

Yes. I strongly suggest you read the Help page for the VLOOKUP function.