Finding Multiple Criteria in an Excel Book

[alex.williams]

Hi all

I'm not sure if this is even possible in excel but I have multiple spreadsheets with charts of numbered data in and I have 3 criteria's on which to search for.

The first being the postcode, for instance the user would put the postcode into the first cell so it knows which spreadsheet to look for in the book (there is a separate spreadsheet to cross reference the postcodes to the right spreadsheet)

The second cell being a number, the user would input the number to find which row and the third cell being a number, the user would input the number to find which Column. The criteria to search for would be in the first column and first row so it would return the value A23 for example.

For example;

Postcode (sheet) / number in column a / number in row 1 / Result.

Any help would be much appreciated as my brain is starting to expand and I fear it may explode.

Thank you

[hemesh]

Hello Alex can you post a sample book. I think this can be done

[alex.williams]

Irradiance Datasets.xlsx

Thank you for your help