Forum Discussion
vlookup across multiple sheets
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. Formu...
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