Vlookup on multiple columns not working

[robcampbell]

This Vlookup should work I think but it isn't.

Current table does have more columns in between Service Indicator and Support Activity. There is a column at the end of the current table to hold the formula

Formula
{=INDEX(Table5[@[MSR Category ]],MATCH(Table5[Service Indicator]&Table5[Support Activity],[@[Service Indicator]]&[@[Support Activity]],0))}

Table5

[TABLE="width: 552"]
<tbody>[TR]
[TD]Service Indicator[/TD]
[TD]Support Activity[/TD]
[TD]MSR Category[/TD]
[/TR]
[TR]
[TD]0% error[/TD]
[TD]Update gradebook[/TD]
[TD]System[/TD]
[/TR]
[TR]
[TD]21 day auto-drop[/TD]
[TD]Provide policy instruction[/TD]
[TD]Admin[/TD]
[/TR]
[TR]
[TD]Accidental drop[/TD]
[TD]Support enrollment[/TD]
[TD]Admin[/TD]
[/TR]
[TR]
[TD]Account merge needed[/TD]
[TD]Merge account[/TD]
[TD]System[/TD]
[/TR]
[TR]
[TD]All Attempts Used[/TD]
[TD]Reset exam[/TD]
[TD]System[/TD]
[/TR]
[TR]
[TD]Answer changed[/TD]
[TD]Reset exam[/TD]
[TD]System[/TD]
[/TR]
[TR]
[TD]Attempts out of order[/TD]
[TD]Update gradebook[/TD]
[TD]System[/TD]
[/TR]
[TR]
[TD]Auto submit[/TD]
[TD]Reset exam[/TD]
[TD]System[/TD]
[/TR]
[TR]
[TD]Blank gray screen[/TD]
[TD]Troubleshoot[/TD]
[TD]System[/TD]
[/TR]
[TR]
[TD]Broken link - CL[/TD]
[TD]Update course content[/TD]
[TD]Content[/TD]
[/TR]
[TR]
[TD]Broken link - DL[/TD]
[TD]Update course content[/TD]
[TD]Content[/TD]
[/TR]
[TR]
[TD]CL content assistance[/TD]
[TD]Escalate request[/TD]
[TD]Admin[/TD]
[/TR]
[TR]
[TD]Content challenge[/TD]
[TD]Reset exam[/TD]
[TD]Content[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]



Result Table


[TABLE="width: 573"]
<tbody>[TR]
[TD]Service Indicator[/TD]
[TD]Support Activity[/TD]
[TD]Result[/TD]
[/TR]
[TR]
[TD]0% error[/TD]
[TD]Update gradebook[/TD]
[TD]#VALUE![/TD]
[/TR]
[TR]
[TD]21 day auto-drop[/TD]
[TD]Provide policy instruction[/TD]
[TD]#VALUE![/TD]
[/TR]
[TR]
[TD]Accidental drop[/TD]
[TD]Support enrollment[/TD]
[TD]#VALUE![/TD]
[/TR]
[TR]
[TD]Account merge needed[/TD]
[TD]Merge account[/TD]
[TD]#VALUE![/TD]
[/TR]
[TR]
[TD]All Attempts Used[/TD]
[TD]Reset exam[/TD]
[TD]#VALUE![/TD]
[/TR]
[TR]
[TD]Answer changed[/TD]
[TD]Reset exam[/TD]
[TD]#VALUE![/TD]
[/TR]
[TR]
[TD]Attempts out of order[/TD]
[TD]Update gradebook[/TD]
[TD]#VALUE![/TD]
[/TR]
[TR]
[TD]Auto submit[/TD]
[TD]Reset exam[/TD]
[TD]#VALUE![/TD]
[/TR]
[TR]
[TD]Blank gray screen[/TD]
[TD]Troubleshoot[/TD]
[TD]#VALUE![/TD]
[/TR]
[TR]
[TD]Broken link - CL[/TD]
[TD]Update course content[/TD]
[TD]#VALUE![/TD]
[/TR]
[TR]
[TD]Broken link - DL[/TD]
[TD]Update course content[/TD]
[TD]#VALUE![/TD]
[/TR]
[TR]
[TD]CL content assistance[/TD]
[TD]Escalate request[/TD]
[TD]#VALUE![/TD]
[/TR]
[TR]
[TD]Content challenge[/TD]
[TD]Reset exam[/TD]
[TD]#VALUE![/TD]
[/TR]
</tbody>[/TABLE]

 

[Marcelo Branco]

Great!

@ means the value in This Row

See the topic Special item specifiers at
https://support.office.com/en-us/ar...l-tables-F5ED2452-2337-4F71-BED3-C8AE6D2B276E

You are welcome. Thanks for the feedback.

M.