Hi Dawn,
You can use a combination of the
IF and
VLOOKUP functions to achieve this. Here are the steps:
- In a new column, use the following formula to check if the cell contains the word "Secure Plus":
Formula:
=IF(ISNUMBER(SEARCH("Secure Plus",A2)),"Yes","No")
Note: Replace A2 with the cell reference of the first cell in your data range.
- Copy the formula down to all the cells in the column.
- Now, you can use the VLOOKUP function to lookup the value you need based on the "Yes" or "No" result in the new column. Here's an example formula:
Formula:
=VLOOKUP("Yes",B:C,2,FALSE)
Note: Replace B:C with the column range that contains your data and the lookup value, and adjust the column number (2 in this example) to match the column number of the value you want to return.