I have had help in building the attached formula.
It looks up the job code, and then returns the narrative in column Q - but as I drag the formula down, it'll only include the 2nd, 3rd and 4th values in the column (so it avoids the duplication of the first value as a vlookup would do).
However, I now want to amend the formula so that it will return values based on the current criteria, but also dependent on whether column B says 'Accrued Cost".
=IFERROR(INDEX(PL!$Q$44:$Q$47,SMALL(IF(PL!$S$44:$S$47=PL!$C$11,ROW(PL!$S$44:$S$47)-ROW(PL!S$44)+1),ROWS(PL!B$34:B34))),"")
If you can help me, that would be amazing!
Thanks in advance
Ryan
Bookmarks