Formula Request for Searching Between Columns.

[dbsbender]

The search needs to search column 3 for the numbers in column "Included" and "Excluded"
The columns have more than 10k lines
The search is anywhere in column 3

Thank you in advance for any help.

 

[NARAYANK991]

Hi ,

See if this helps.

Narayan

 

[Somendra Misra]

Hi dbsbender,

Assuming you want result as column E,F,G see the attached file for alternate solution in Column H,I,J yellow cells.

Regards,

 

[dbsbender]

Hi dbsbender,

Assuming you want result as column E,F,G see the attached file for alternate solution in Column H,I,J yellow cells.

Regards,

Thank you so very much - greatly appreciate the help.