Find the next active cell and HLOOKUP above it...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

H
I need a formula that will look at a range of cells across one row (eg O14:BC14), find the first active one (regardless of the number entered into it) then Hlookup the corresponding date entered 4 rows above it. I tried FIND or SEARCH but they didn't work

As always - help would be greatly appreciated..
 
One way:

=INDEX(O10:BC10,COUNT(O14:BC14))

HTH
Jason
Atlanta, GA
-----Original Message-----
Hi
I need a formula that will look at a range of cells
Click to expand...
across one row (eg O14:BC14), find the first active one
(regardless of the number entered into it) then Hlookup
the corresponding date entered 4 rows above it. I tried
FIND or SEARCH but they didn't work?
 
Solution given: =INDEX($O$11:$BC$11,COUNT(O14:BC14)
Thanks Jaso
I tried that but where one active cell is present (rows 13 & 16) it gave 4/4 as the answer and for row 15 it gave an answer of 18/4?? Any advice

Col O P Q R S T U V W
Ro
10 4/4 11/4 18/4 25/4 2/5 9/5 16/5 23/5 30/
11
12
13 100
14
15 1 1
16 1
 
Back
Top