Hi Guys,
I need your help to find a clue how to build this formula to list Case numbers from returned surveys based on customer mobile number. Please see short example down below. I was trying few combinations of VLOOKUP, INDEX, MATCH, but without success. Any clue? Thanks. Rich.
<tbody>
</tbody>
I need your help to find a clue how to build this formula to list Case numbers from returned surveys based on customer mobile number. Please see short example down below. I was trying few combinations of VLOOKUP, INDEX, MATCH, but without success. Any clue? Thanks. Rich.
We sent surveys to group of customers | Surveys returned from mobile numbers … | ||||||
Description | Case number | Mobile1 | Mobile2 | Mobile3 | Surveys | Search for Case number | |
Descripton1 | 123 | 111 | 333 | Formula? | Should return Case number 789 | ||
Descripton2 | 456 | 222 | 555 | Formula? | Should return Case number 852 | ||
Descripton3 | 789 | 333 | not returned | ||||
Descripton4 | 963 | 444 | not returned | ||||
Descripton5 | 852 | 555 | not returned |
<tbody>
</tbody>