Getting indirect to work with offset

Thanks to RGonzo who got me set up with a formula to cross reference headings etc. However I have now tried to implement the same formula for the sheet Dashboards (B5) that would reference the date headings. Alas, I am bogged down in it.  Thank you for your help - as always.
EE_Project_08.xlsx
LVL 1
agwalshAsked:
Who is Participating?
 
Neil FlemingConnect With a Mentor Independent consultantCommented:
Is your problem with the #NA on your sheet? If so, it looks like there are a couple of problems with the formula in B5.

It references column I in the "All" worksheet, instead of column K; and I1:B1 instead of L1:T1.

It is also returning an #NA, because "Total WTE" does not exist in the "All" sheet.

Apologies if I've misunderstood the issue.
0
 
agwalshAuthor Commented:
I went back to the formula, re-adjusted it and got it working myself.
0
 
agwalshAuthor Commented:
Went back to drawing board, adjusted the formula again for my new settings and got it working.
1
 
Neil FlemingIndependent consultantCommented:
Glad that worked.
1
 
agwalshAuthor Commented:
I just needed to get away from it and come back fresh to it this morning...
0
All Courses

From novice to tech pro — start learning today.