IF AND/OR plus a VLOOKUP
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?
Best Answer
-
Give this a try:
=IF([CRM Portfolio]@row = 1, IF(Jurisdiction@row = "Federal", "Jason", VLOOKUP(State@row, {CL_States Range 2}, 2, false)))
Answers
-
Give this a try:
=IF([CRM Portfolio]@row = 1, IF(Jurisdiction@row = "Federal", "Jason", VLOOKUP(State@row, {CL_States Range 2}, 2, false)))
-
@Paul Newcome That did it! THANK YOU!! I was making it more complicated than it needed to be :)
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 61 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!