One to many items match

Hi Pavan,

column D has many values (negatives / positives).. what you need ? do you need the row numbers of next available matches?

See the attached file where I have tried obtaining a match of a cell which is highlighted in yellow.. you can get some hint from that. thanks.




Regards,
DILIPandey

<click on below 'star' if this helps>