Forum Discussion
Excel Formula to Pull Cell Data Based on Column Header (Date) and [Similar]Row Header (Name)
Hello all, This is the first time I've posted and, please forgive me if this is a problem that someone else has already had solved... I have been looking for an answer for 2 weeks and I just don't ...
Formula in column B:
=FILTER($I$2:$I$15,ISNUMBER(FIND(A3,$I$2:$I$15)),"NF")
You can then use the value that formula returns as a lookup value using index match, use this formula for Secondary Table: INDEX($A$2:$H$18,MATCH(FILTER($I$2:$I$15,ISNUMBER(FIND(A3,$I$2:$I$15)),"NF"),$A$2:$A$18,0),MATCH('ORL Sales Board'!$B$2:$F$2,0))
cheers