Hi

Here's one way.

on sheet 3 row 1, put in the required statements for the relevant columns eg
E1: Follow up Relevant Pages
F1: Follow up Submission
on sheet3 row 2 down, put in a formula to test the respective cell on sheet work eg
E2: =ISBLANK(Work!E2)
F2: =ISBLANK(Work!F2)

On sheet work
B2: =INDEX(Sheet3!$1:$1,,MATCH(TRUE,Sheet3!2:2,0))

This will find the first appearance of a true in sheet3, and find the relevant heading that matches.


For the formula in work!C2, you could build a lookup table with the heading results to be found in B2, a cell reference (e2, f2 etc) and the amount that has to be added (1,2...)

Something like
Follow Up Submission,E2,1
chaise AIP,F2,2

Then you could use a formula similar to

=INDIRECT(VLOOKUP(B2,Sheet3!A4:C5,2,FALSE))+VLOOKUP(B2,Sheet3!A4:C5,3)

to bring back the relevant result. In this example, I've put the lookup table in Sheet3:A4:C5 but that would probably have to be moved...

HTH

rylo