Hi

I have a sheet (sheet 1) of financial data for multiple buildings as follows:

Building Budget Type Budget £

Centre A Employees £1
Centre A Premises £2
Centre A Supplies £3
Centre A Income £4
Centre B Employees £5
Centre B Premises £6
Centre B Supplies £7
Centre B Income £8
Centre C Employees £9
Centre C Premises £10
Centre C Supplies £11
Centre C Income £12
etc, etc, etc

As you can see, column A is in blocks (4 lines of the same name) and column B has repetitve lines over 4 lines.

From another sheet (sheet 2), I wish to be able to specify a buidling (Centre B) and budget type (Supplies) and return the value in budget £ (£7)

I was considering using VLOOKUP but the data is not sorted alphabetically and I really need to find a way to keep it in its original list.

Any help would be much appreicated, thanks in advance