Hi all
I have a spreadsheet that requires a reference number (SDAC REF) to be input which then triggers the VLOOKUP for the SDAC Name & STW Catchment. This all works fine until a reference number with (????E1??) is input, this then changes the cell to Scientific and the VLOOKUP does not work...