pick up first field that isn't blank

[kgkev]

My column "O" contains data that looks like

Excel Workbook
	O
20	V/c
21
22
23
24	V
25
26	V
27	V
28	V
29
30	V
31
32
33
34
35
36
37
38
39
Invoice

Excel 2000

Cell Formulas
Range	Formula
O21	=Data!M9
O22	=Data!M9
O23	=Data!M10
O24	=Data!M11
O25	=Data!M12
O26	=Data!M13
O27	=Data!M14
O28	=Data!M15
O29	=Data!M16
O30	=Data!M17
O31	=Data!M18
O32	=Data!M19
O33	=Data!M20
O34	=Data!M21
O35	=Data!M22
O36	=Data!M23
O37	=Data!M24
O38	=Data!M25
O39	=Data!M26

I need to return the V else where but can never be certain where it might appear.

the letter will always be the same so if I can just identify the first one that would be fine.

 

[West Man]

Try: =INDEX($O$21:$O$39,MATCH(TRUE,O21:O39<>"",0))

Confirmed with Ctrl Shift Enter

 

[kgkev]

Thanks for that - I have a problem though

I get a message - Array Formulas are not Valid in Merged Cells.

Is there a way round this without reformating my whole page?