Can I have multiple match values

[Engine1911]

Building a manpower document that fills in from a master roster. I assign positions based on a designated value assigned. The macro I use works but I also would like it to assign multiple values in a range of cells. So if I have it looking for “T” it lists everyone with a t next to their name. I also want it to find “OT” and list in those same range of cells. So multiple match values. The part in the macro is if(c6:c78=“T”,ROW(c6:c78)). Can I add more than just “T”?

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...rch-return-using-index-match.html#post5155778

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.