Regarding this formula:
=LOOKUP(10^10,A2:F2)

1) the LOOKUP function has a neat feature. If the lookup value is larger than every value of the same type (numeric or text) in the lookup range...it matches on the last value of that type.
2) If you want to use the largest number that Excel can handle, use: 9.99999999999999E+307
However, that's more typing than I prefer. Consequently, I use 10^10...which works for every application, except maybe astronomy