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