Okay! We are making some progress, but I hit another roadblock.

Here is the formula exactly as it is entered in the first row in cell F78.

=IF(ISBLANK(D78),"",VLOOKUP(D78,LU_Ktype,BK68:BK86 ,BK68:BK86))

So when I scroll to "0.25" in cell D78 I get "0.146" in cell F78
GREAT!!!
Now, if I go down 1 row to cell D79 and copy the same list for a drop down
menu and type the following formula in cell F79:
=IF(ISBLANK(D79),"",VLOOKUP(D79,LU_ktype,BK68:BK86 ,BK68:BK86))

I get a reference error. I am referencing the same list name so why won't it
just do the same as the cell above?

Thanks ,
Neil