G
Guest
I have a problem with one of my spreadsheets.
I have worksheets for 12 months of the year(Jan-Dec) and a summary sheet.
The format for each sheet and summary sheet has names down one side and code
names going across as shown.
A B C
Hotel Travel
1 John Smith 300
2 Barry George 29
The current formula is simple and prone to errors when inserting new
columns/rows. Jan B1+Feb B1 and so on to return the total for all months in
the summary sheet.
Firstly I dont think it is possible but can you vlookup using two references
e.g search by John smith and Hotel to return 300?
Secondly what do you suggest is the best formuala to use in this situation
for it not to look too messy.
I have worksheets for 12 months of the year(Jan-Dec) and a summary sheet.
The format for each sheet and summary sheet has names down one side and code
names going across as shown.
A B C
Hotel Travel
1 John Smith 300
2 Barry George 29
The current formula is simple and prone to errors when inserting new
columns/rows. Jan B1+Feb B1 and so on to return the total for all months in
the summary sheet.
Firstly I dont think it is possible but can you vlookup using two references
e.g search by John smith and Hotel to return 300?
Secondly what do you suggest is the best formuala to use in this situation
for it not to look too messy.