IF AND/OR plus a VLOOKUP

Options

I'm having trouble getting a formula correct; I keep getting unparsable or circular reference. I'm wanting to add the name of our rep based on the status of two columns. If the CRM Portfolio is checked AND the Jurisdiction = Federal, I want to insert the name "Jason". If the CRM Portfolio is checked and the Jurisdiction is something other than federal, I want it do a VLookup in another sheet based on the State to pull the CRM contact for that state.

I've tried - =IF(AND([CRM Portfolio]@row=1,[Jurisdiction]@row="Federal","Jason",(IF(AND([CRM Portfolio]@row=1,[Jurisdiction]@row=0,(VLOOKUP([State]@row,{CL_States Range 2},2,false))))))

This comes back as a circular error. Any suggestions?



Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!