=IF(ISBLANK($T$3),0,INDEX(Sheet1!1:80,$T$3,34))
What I'm trying to accomplish with this is change the column 34 statement at the end of the formula into find the first populated cell between column 34-40 and fill the current cell with the "TEXT" that is in the first populated column.
Any help would be extremely appreciated!