I don't know if this is abiding by forum rules (I dind't find anything in there) but I have a follow up question.
So based on your eloquent formula, I've modified it to the following:
What I need to do is further modify the section:
I realized I can't point at just this column (the S column). I need to choose between 13 different columns based on a value I have in the current worksheet, column H. Column H (located in the worksheet where the formula is, not the 090911 FGI.xls) is going to contain the correct column title for which to search:
So, I thought about using an Hlookup, and I came up with
This mostly gives me an #N/A error, but sometimes it works...very weird can't figure out the pattern of why or why not. So maybe some kind of integration between this and the original?
Bookmarks