Formula that "looks up" to get data if not present, allowing blank cells?

Hi all,
Question for you:

Excel Question.JPG

Assuming your (sparse) data starts in A2 rather than A13 as shown, you can put this formula in C2:

=LOOKUP(9^9,A$2:A2)/LOOKUP(9^9,B$2:B2)

then copy it down as far as you need to.

Hope this helps.

Pete

Try this. In C2 thendrag down.

=IFERROR(A2/B2,"")