Add criteria to existing formula that references another worksheet in Excel

Column J in UDS! has the current formula:
=IF(LEN([@[Work_Order_ID]])<10,"Land Use","WO")

I would like to revise the Column J formula as follows:
IF(LEN([@[Work_Order_ID]])<10,"Land Use"
If ([@[Work_Order_ID]]) is listed in PLAN10!Id (Column A), and the PLAN10!Close Work Order (Column E) = "Yes", then UDS!Type_Task (Column J) = "AFI"
Else
UDS!Type_Task (Column J) = "WO"

I have attached a sample spreadsheet, and entered the results in red under UDS!Type_Task that I am hoping for.

Thanks,
Andrea
EE_Example.xlsx
AndreamaryAsked:
Who is Participating?
 
Ejgil HedegaardConnect With a Mentor Commented:
See column K in attached
EE_Example.xlsx
0
 
AndreamaryAuthor Commented:
Perfect, and a very quick turnaround! Thanks very much, Ejgil!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.