Forum Discussion
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 AmairahSilver 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 SCopper ContributorThanks very much for the reply. I will give that a go and see what happens.