Skip to main content

All 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 ...
AdrienNK's user avatar
  • 123
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, ...
NATHAN ARNOLD's user avatar