J

#### Jim

I would like to reference a cell for data, however if that cell is blenk

then look at the next cell, etc. For example:

In P1 I would like to reference cell F1, but if E1 is blank then the formula

looks at D1, and if D1 is blank I would like to look at C1, if C1 is blank I

would like to look at B1, and if B1 is blank I would like to populate P1 with

the data from A1. A1 will always have data, but the other cells may be blank.

Thanks in advance for the help.

Jim