Lookup Formula

J

JES

Having trouble with a lookup when searching fo rhte first nonblank cell as a
reference point.

A B C D E F G
1 24 24 24
2 18 12 12
3 8
4 06/15 06/22 06/29 07/06 07/13 07/20

In cell A1 I need a formula that will return 07/06, A2 returns 06/22, and A3
returning 07/13.
 
S

ShaneDevenshire

Hi Jes,

Array enter the following formula:

=OFFSET($A$4,0,MATCH(TRUE,ISBLANK(B3:G3),0))

and copy it down. By array enter we mean press Shift Ctrl Enter instead of
Enter to enter the formula.
 
T

T. Valko

Try this:

=INDEX(B$4:G$4,MATCH(TRUE,INDEX(B1:G1<>"",,0),0))

Copy down as needed
 
R

RagDyer

Nice ! ... and to save a few keystrokes:

=INDEX(B$4:G$4,MATCH(TRUE,INDEX(B1:G1<>"",),))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top