How about entering 0 for those cells that contain 'nothing'. This way
you can use the following formula...

=LOOKUP(9.99999999999999E+307,D48:K48)

And, if you want to hide zero values, you can custom format your cells
as follows...

1) Select/highlight your range of cells

2) Format Cells Number Custom Type: 0;-0;;@

Would this work for you?

In article ,
flapokey
wrote:

Hello,

Thank you for all the help. But I am still getting nothing in G2 to
appear. I tried all the formulas. I am not using a Lookup table. If
you could futher help me I would be greatful. Thanks flapokey