I have a worksheet where one column shows a code followed by one of four options (Deliverable 3, IFC Engineering Workpack complete, IFC Construction Workpack, Land Access Granted - eg (McFarland D.10RP185773) Final IFC Engineering Workpack Complete) which are generated using a vlookup function. In the adjacent cell, I need to find a function which will return a letter based on which of the four optios is displayed, but as the code at the start of the text is necessary for ID, the funtion needs to look at whether the cell contains certain words. I tried using the IF Function, but can only return one result.
I need the function to do the following:
If cell contains Deliverables, return "a"
If cell contains Engineering, return "b"
If cell contains Construction, return "c"
If cell contain Land, return "d"
I tried =IF(ISNUMBER(SEARCH("Land",F2:F3)),"d","") but got stuck there. I cannot get my head around how to return a different value based on which of the four options appears in the cell.
I really hope that makes sense! If anyone has a suggestion I would be really appreciative.
Bookmarks