IluvPivots
Board Regular
- Joined
- Feb 13, 2007
- Messages
- 141
- Office Version
- 2016
In Sheet "Justification Template" I need a formula.We are returning a value from sheet "CIV Endstrength". The formula will be in sheet "Justification Template".Using the value in cell A10 of "Justification Template"...take that value and look for it in all of "CIV Endstrength" Sheet. Once excel finds it in "CIV Endstrength"...in that tab...go down 6 rows and over 3 coumns. Return that value.