Forum Discussion

Copper Contributor

Apr 23, 2020

Index Match: search for a string and return multiple values

I'm looking to do a lookup, and I assume index match is the rout to go, but I'm not certain. The lookup value will always be a single line, but the column I'm searching for a match on may have multip...

lookup sample.xlsx11 KB

excel

Formulas and Functions

office 365

wumolad

Iron Contributor

Apr 23, 2020

Zexall Hi.

The dataset looks somehow. Why do you have several items in each cell in column A? I suggest each cell should have a unique lookup value to make this exercise easier. Is this the only way the report can be generated or you can generate the report wit each item in each cell?