Look up cell from specific column and row

[bjbboats]

Hi all

Looking for some help on weekly reporting.

I have a back sheet with a number of tables (different geo locations we do business in) labelled 1-52 in the first row of the table (weeks) and column names along the top of the tables for the products we sell.

I'd like a formula that looks up in a selected table the column name (product) and the week number to pull through that weeks figure to a summary sheet on another tab.

I'd also like to be able to update the formula with the new business week. Hoping to be able to do that by a find and replace.


Hopefully that makes sense!!

Thanks for any help.

[etaf]

you maybe able to do that with a indirect and a index/match
the indirect would look at a cell with the week in and then use that sheet and lookup the product and location

BUT to get the formula right

Please upload a sample of your workbook to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
Would like to see an example of your data and also a manual mock up of the expected results you want to achieve.

To attach a file to your post,
click "Go advanced" (next to quick post),
scroll down until you see "manage Attachments",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.