vlookup across multiple sheets

[marisa1978]

I am trying to use the VLOOKUP formula to do the following:

"...determine the allocated speakers expense for each location"

I have 3 sheets, set out the same, that i need to use this formula. Formula being on fourth 'Totals' sheet.

Anyone help please?

have attached the file i am using.

[#2]

@marisa1978 

Not sure exactly what info you want to fetch from the location sheet and in which cells on the fourth sheet.

Can you upload the file again after mocking up the desired output manually and applying a different interior color to the mocked up cells?

[#3]

@marisa1978 

Hi Marisa

I have attached a file  with the speaker totals updated in the total cost summary sheet - is this what you want?

It works by adding the cells in each sheet Sydney, Adelaide and Perth. The important point is that the 3 sheets must always be in the same format or it won't work. So  Speaker 1 figure is on cell B18 for the 3 sheets. If you add (say) another 5 speakers you must make sure they are on the same cells in each sheet.

if you decide to add another location (say Brisbane) you can insert it before Perth and solong as it is in the same format the totals will filter through.

I hope this is what you wanted. If it is please mark this solution as complete.

thank you.

Peter