For RagDyeR : Lookup in multiple columns

  • Thread starter Thread starter sapai
  • Start date Start date
S

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?
 
Check your OP for an answer.

It's best to always stay with your first thread.
 
=IF(COUNTIF(A2:E50,"boost"),INDEX(F2:F50,MAX((A2:E50="boost")*ROW(1:49))),"")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup in multiple columns 7
Help needed 0
Lookup returning wrong results 0
Returning multiple instances of the same lookup value 0
Vlookup and return sheet name also 2
Embedded lookup 3
lookup 4
Lookup / Summary Table 8

Back
Top