return number from column if number is greater than and return result from different cell.

my knowledge with excel is limited and i dont know how to do this. Any help would be greatly appreciated. Thank you.

If a number in the column C1:C10 > A1 then return the value from B cell of that same row

thanks for the reply guys! I want to condense it to only one cell, rather than copying it all the way down. I want the formula to go down each cell and return the first cell that makes that statement true. I thought the solution might be in a combination of index and match. but i have not been able to figure out how to properly use them to return a number from the cell over. thanks again for your help!

Try

=IFERROR(INDEX($B$1:$B$10,SMALL(IF($C$1:$C$10>$A$1,ROW($B$1:$B$10)-ROW($B$1)+1,""),ROWS($B$1:B1))),"")

will return all values from B where C> A1

=IFERROR(INDEX($B$1:$B$10,SMALL(IF($C$1:$C$10>$A$1,ROW($B$1:$B$10)-ROW($B$1)+1,""),1)),"")

Will return first

Enter both with Ctrl+Shift+Enter

Fantastic! Just what i was looking for. I may have had more success if i knew about ctrl+shift+enter before. Thanks so much! i was struggling with this problem for quite some time, thanks again!

Thank you for the feedback. If your problem has been addressed please mark the thread as SOLVED ("thread Tools" at top of post).