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...
=IF($D$2:$D$100=1,$B$2:$B$100,"")
returns blanks...
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...
=IF($D$2:$D$100=1,$B$2:$B$100,"")
returns blanks...