Hi all,
Here's my formula in a cell:
=INDEX(Sheet1!U:U,MATCH(Test!A2,Sheet1!$E:$E,FALSE))
How can I add a formula within the cell to include, IF="Fully Lined", "Yes", "No"
Basically if the value from the index match returns Fully Lined, change it to Yes, or No (if it does not return fully lined)
Thank you
Bookmarks