I am trying to do a vlookup for a number that has one decimal. The number will always be "5" but the decimals can be from 0-9 (e.g. 5.2, 5.0, 5.9)
I tried to concatenate vlookup(5&".'&"*",table,4,false) but it doesn't work.
I cannot vlookup a cell (such as A3 or B4), bc I am looking for the...