Vlookup formula issue


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)




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!