vlookup is not finding reference numbers from one worksheet to another in
same excel file. I have tried copying formats from lookup column to reference
column in data worksheet. I have made lookup range absolute by using $
prefixes