All Questions
2
questions
1
vote
0
answers
296
views
Excel: VLOOKUP with cell containing multiple references
I have a table which contains multiple references per cell separated by a blank space.
In an other table that contains one line per reference, I want to use VLOOKUP to retrieve the name of the ...
0
votes
1
answer
3k
views
Formula to display text from multiple cells from one sheet in another
I have a list of sales reps and the names of the customers they've sold product to, on one sheet. I have tried VLOOKUP, but it will only return one set of text from the cells. I would like to know, ...