How do I find the First Blank Cell in a Row & Return the Value adjacent to the Blank Cell?
In the attached pic. In the row range (F3:I3), I need to locate the blank cell (I3) and Return the Value "3" in the adjacent cell (H3).
I've tried a little of everything (Arrays, nested formulas like Match, etc) with not much luck. Thank you in advance for your help.
Blank Cell.JPG
Try this:
=INDEX(F3:I3,MATCH(TRUE,INDEX(F3:I3="",0),0)-1)
Try one of these array formulas**...
=INDEX(F3:I3,MATCH(TRUE,F3:I3="",0)-1)
If you need an error trap:
=IFERROR(INDEX(F3:I3,MATCH(TRUE,F3:I3="",0)-1),"")
** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Thank you Everyone! That worked perfectly.
You're welcome. We appreciate the feedback!
If your question has been solved please mark the thread as being solved.
In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks