Incorporating an Offset into a formula

[Joe Galvan]

I have a formula that does great for pulling the first item in a string but I need the 2nd, 3rd, etc... in the string of informtaion

Currently I am using:

Index(ResultsRange,match(1,if(range1=LookupValue1,if(range2=LookupValue2,if(range3=LookupVAlue3,1))),0)) C+S+E

Is there a way to put an offset into this formula, so I can pull the next item down??


thanks,
JOE

 

[barry houdini]

Hello Joe, you can use this version in D2 confirmed with CSE and copied down

=INDEX(ResultsRange,SMALL(IF(range1=LookupValue1,IF(range2=LookupValue2,IF(range3=LookupVAlue3,ROW(ResultsRange)-MIN(ROW(ResultsRange))+1))),ROWS(D$2:D2)))

You'll get an error (#NUM!) when matches run out, you can use IFERROR or other options to prevent that if you want

 

[Joe Galvan]

Thanks, it worked great!!! I just didnt think about the duplicates that I may encounter, but I might have a plan for that...


thanks again Barry...