For RagDyeR : Lookup in multiple columns

[sapai]

I have hit one more problem with this formula. If I change the lookup <in
this example "boost"> as dynamic variable for each row, and if one of this
value donot exist in A2:E50, it is returning me by default first value in
cell F2.

Is there a way to force blank in this cell with the same formula?

 

[RagDyer]

Check your OP for an answer.

It's best to always stay with your first thread.

 

[Bob Phillips]

=IF(COUNTIF(A2:E50,"boost"),INDEX(F2:F50,MAX((A2:E50="boost")*ROW(1:49))),"")