Find value in first non blank cell

[GeeWhiz04]

I've been trying to enter a formula to find the value in the first non blank cell in a row. For example, if cell B2, C2 & D2 are blank but E2 has a value, what formula would i use to copy that value into A2

[63falcondude]

Here's one option:

=INDEX(B2:G2,MATCH(TRUE,B2:G2<>"",0)) Ctrl Shift Enter

or

=INDEX(B2:G2,INDEX(MATCH(TRUE,B2:G2<>"",0),0))

[GeeWhiz04]

Thanks, I was close, but couldn't get the formula to work. Your formula works perfectly. thanks again

[63falcondude]

You're welcome. Happy to help.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.