Hello,

I have been asked to simplify (cough! cough!) a spreadsheet with over 50 tabs. It has complicated vlookups.

I have suggested an Access database would be better but others would rather have a spreadsheet. However, I am reorganising the data to make it easier to deal with.

Now to the problem:

This spreadsheet is for holding lots of profile information on doctor surgeries.

These profiles can change for each individual surgery and on a quarterly basis. So there needs to be a way of grabbing one cell of data based on these two factors.

Any ideas?

To obtain a cell in a workbook you need sheetname and cell ref how does what you have translate into that information. I think that it will be impossible to help without some sight of typical data.
Unfortunately I wont be around for the next 3 days but anybody who wishes to help will, I believe, need that info.

Brian

Typical data attached.

I would like the percentage for any combination of K-Code and quarter. The current spreadsheet filters on these columns independently which is something I am happy to stay with.

I have found a solution.

I have two drop down boxes which I concatenate and use as the source for a Vlookup to find the data I want.