Forum Discussion
Solved
How to lookup and retrieve data using multiple data points
I need to determine whether an agent offers a particular service, but there are multiple agents sharing names across locations offering different services. I would like the solution to be able to ref...
=TEXTJOIN(", ",,FILTER($C$3:$C$18,($A$3:$A$18=E2)*($B$3:$B$18=F2)))Is this similar to what you are looking for? The formula is in cell G2 and filled down to G7. The ranges of the formula can be adapted as required.
=TEXTJOIN(", ",,FILTER($C$3:$C$18,($A$3:$A$18=E2)*($B$3:$B$18=F2)))Is this similar to what you are looking for? The formula is in cell G2 and filled down to G7. The ranges of the formula can be adapted as required.
Thank you so much!
*Edit - OMG it also allows you to add multiple services for the same agent. You're literally heaven sent... this will make my day so much easier.
