BlasterBates is probably right, sometimes a spreadsheet can go haywire when it's had data imported into it from elsewhere. I've seen it a few times and it's completely unpredictable.
Best bet is to start a brand new workbook, then copy and paste values from your broken sheet into a sheet in the new workbook. Then try a new lookup formula in the new workbook and see what happens.
You could also try making a new column in your existing sheet and fill it with =value(A2) (if Col A contains your lookup IDs) and paste down and then do the lookup on that column instead.
You could also try a combination of INDEX and MATCH instead of VLOOKUP.
Best bet is to start a brand new workbook, then copy and paste values from your broken sheet into a sheet in the new workbook. Then try a new lookup formula in the new workbook and see what happens.
You could also try making a new column in your existing sheet and fill it with =value(A2) (if Col A contains your lookup IDs) and paste down and then do the lookup on that column instead.
You could also try a combination of INDEX and MATCH instead of VLOOKUP.
Comment