I am using VLOOKUP as I have many times in the past. The formula I am using
is:

=VLOOKUP($A3,Raw,2,FALSE)

It returns a "0" presumeably becasue it thinks the value in column 2 is "0".
It returns the same thing regardless of the column, with one exception,
column 1. It returns that value appropriately. The format for the columns
vary between numbers, texts, dates.

Thanks in advance