ArbieBrown
New Member
- Joined
- Oct 19, 2017
- Messages
- 5
Long time lurker - now needing help!
Basically I have the following formula:
=INDEX('Data Drop'!$A$1:$N$1000,MATCH($B2,'Data Drop'!$B1:$B1000,0),0)
Which is very good at looking up the requisite information and bringing it back (I have a bunch of them on a sheet which then matches column B's data with the indexed info, to collect the correct output)
It all works great - and is a massive timesaver on a repetitive report.
Or at least it would be
Until I realised that some of the data in Col B now should/could match multiple results.
I cannot for the life of me work out how to convert this effective formula into one that can return multiple results and still work...
Any help - or even some pointers - would be gratefully received!
Basically I have the following formula:
=INDEX('Data Drop'!$A$1:$N$1000,MATCH($B2,'Data Drop'!$B1:$B1000,0),0)
Which is very good at looking up the requisite information and bringing it back (I have a bunch of them on a sheet which then matches column B's data with the indexed info, to collect the correct output)
It all works great - and is a massive timesaver on a repetitive report.
Or at least it would be
Until I realised that some of the data in Col B now should/could match multiple results.
I cannot for the life of me work out how to convert this effective formula into one that can return multiple results and still work...
Any help - or even some pointers - would be gratefully received!