Vlookup formula issue

Sara.Mayol

Hi there-

I had a formula entered into my worksheet that would auto-assign a colleague to order requests based on what groups they did ordering for. Somehow the formula was augmented so that it no longer worked. (i.e., I don't know what happened! I'm still learning.) I have the corresponding columns in the primary worksheet linking to a secondary worksheet that lists the different groups who place orders, the colleague assigned to that group, and the colleague's email address. What I having a hard time with is getting the formula right again. Below I have copied an approximation of the formula I had before but I know I am missing something. It keeps coming back #unparseable.

=VLOOKUP([Lab Name]@row, {Lab Assignments Range 2}, 2)

TIA!

Paul Newcome

Try an INDEX/MATCH instead.

=INDEX({Email Address Column}, MATCH([Lab Name]@row, {Lab Name Column}, 0))