Forum Discussion

C S's avatar
C S
Copper Contributor
Mar 13, 2018

Vlookup with multiple answers and colum title look up

I hope I can describe this correctly.  What I'm trying to do is use Vlookup (or anything else that would work better) to find the correct row for my reference, then have it return all numbers that it finds in the array as well as the text in the top of that column.   For example, if I entered "Totals" into the cell for my Vlookup it would look across my columns in the array and return all numbers it found and the title (Cell 1 for the column).  So the result would look like this...... "Totals" in the entry column and in the return cell would read "Bears 5, Hippos 4, Fish 6"

 

Have an example attached. Hopefully that will help clear things up

 

 

2 Replies

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor

    Hi,

     

    If you have an Office 365 subscription, please take this solution:

    =TEXTJOIN(", ",TRUE,IF(ISNUMBER(B5:F5),B1:F1&B5:F5,""))

    But to enter this formula, you have to press Ctrl+Shift+Enter at the same time to get the result because it's an array formula.

     

    Please find the attached file.

     

    Hope that helps

    Haytham

    • C S's avatar
      C S
      Copper Contributor
      Thanks very much for the reply. I will give that a go and see what happens.