First of all thank you for taking the time to read my question, and provide an answer if possible.
My apologies if this is already answered on the forum, I did search for it but could not find how to do this sort of match either with either a vlookup or index match, as in my case I'm searching for the existence of any one of a number of values.
Here's what I'm trying to accomplish.
In the table below, assume columns A,B,C are a table, and columns F,G are a separate table.
I want to fill in column C with the "ticket type" value as listed in column G, so long as there is a match for any of the values in column F in the text within column B.
So the results should be
C2 = "Backup Failure"
C3 = "Backup Failure"
C4 = "Restore Request"
C5 = "Ping Timeout"
C6 = "Hardware Failure"
C7 = "Hardware Failure"
<tbody>
</tbody>
My apologies if this is already answered on the forum, I did search for it but could not find how to do this sort of match either with either a vlookup or index match, as in my case I'm searching for the existence of any one of a number of values.
Here's what I'm trying to accomplish.
In the table below, assume columns A,B,C are a table, and columns F,G are a separate table.
I want to fill in column C with the "ticket type" value as listed in column G, so long as there is a match for any of the values in column F in the text within column B.
So the results should be
C2 = "Backup Failure"
C3 = "Backup Failure"
C4 = "Restore Request"
C5 = "Ping Timeout"
C6 = "Hardware Failure"
C7 = "Hardware Failure"
Ticket | Title | Type | Match Text | Ticket Type | ||
1 | Backup Failure on Server A | Backup | Backup Failure | |||
2 | Server B Failed Backup | Restore | Restore Request | |||
3 | Restore Directory on Server C | Ping | Ping Timeout | |||
4 | Ping Timeout Server D | Hard Drive | Hardware Failure | |||
5 | Server D Failed Hard Drive | Failed Memory | Hardware Failure | |||
6 | Server E Failed Memory |
<tbody>
</tbody>