VLOOKUP formula not working.

[FrancisM]

I have a VLOOKUP in cell F5 that fills the cell with the word No, if "No Show", or other sect text is in cell L5. The formula below works as expected, but I am trying to adapt it to another workbook.

=IFERROR(VLOOKUP(L5,{"No Show","No";"Not Interested","No";"Veteran Canceled","No";"Consult Canceled","No";"Transferred to SE","No";"Not Eligible","No";"Referred to SE","No"},2,0),"")

I am trying to have a similar formula where Yes is in cell range O4:R4, will cause “No” to fill N4.

=IFERROR(VLOOKUP(O4:R45,{"Yes","No"},2,0),"")

I have tried this formula but is is not working. Any advice as to what I am doing wrong?

 

[FrancisM]

I can not thank you enough for your assistance & patience. Once I had a chance to really study your formula, it is so simple & easy to understand. Again thank you.

 

[Aladin Akyurek]

I can not thank you enough for your assistance & patience. Once I had a chance to really study your formula, it is so simple & easy to understand. Again thank you.

You are welcome.