IF Cell Contains This Text VLOOKUP

Hello,

The Status Column has a dropdown menu with multiple options with the text "Completed" and some other options:

  1. Completed awaiting Signature
  2. Completed Reviewing
  3. Completed Approved
  4. Failed
  5. Inspection

I want this formula to work with any options from the drop-down menu with the letter completed. This is what I have so far but it's not working unless I have the exact value between the quotation mark.

=IF([Status]@row = "Completed", VLOOKUP(Address@row, {Range 2023}, 27, false))


Thanks,

Faisal

Answers