Hi,
I require some help please with a lookup formula which includes indirect.
I have a summary sheet and I would like the lookup to look at the sheet based on column C.
I believe the formulas in columns E:H will be similar where it looks up the contract in column D of the summary sheet and matches this with column C of the different sheets.
The trickier formula is column I. Here I need to return the total based on the contract name (column D) add in the word “Total” and then return the value in column X of the different sheets.
I hope that makes sense.
I have include an example. The yellow cells are where the formulas would go. I have included the expected results.
Can anyone help please?
Bookmarks