I need to have a formula that will look at 24 specific cells to find the one whose amount is >0. I can get that part, but what I want to return in the cell is the value in the cell ADJACENT to the one that is >0.

I started with an IF OR formula (currently only showing 5 cell options for brevity) but I'm open to suggestions: =IF(OR(A1>0,A2>0,A3>0,A4>0,A5>0),B1,0)

Where I have "B1" is where I need to fill in something that will make it read the adjacent of the pertinent cell, ie - if A3 is the one with the value greater than 0, then the value of B3 is what will be returned.

Have I explained this right? Anyone have any ideas?