• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

IF and absolute references

Seahorse

Seahorse

Member
=IF($D2=2,$B2,"")

I just need to run down a column looking for a number and then pull the result from a cell in the same row. What I think this should do is check column D for the first instance of '2' and populate the cell with whatever is in the matching row in Column B, and NOT to return a FALSE.

What actually happens is this only works if Row two has a 2 in column D, and if I move the 2 into move it to row 3 it fails. I'm pretty sure the absolute column is not the problem, but my brain hurts and it's been a very long day...o_O

=IF($D$2:$D$100=1,$B$2:$B$100,"")

returns blanks...
 
How about this?
=INDEX(B2:B100,MATCH(2,D2:D100,0))
Returns the value from column B that has a 2 in col D. Then you only need to put this single formula somewhere.
 
You must log in or register to reply here.
Back
Top