I am using VLOOKUP to pull a rate from one workbook to another, but there are two strange things going on:

1. If the lookup value is not in the array, it inserts a number from the table anyway instead of a #REF! error.

2. For 5 specific numbers in the array, if the lookup value is one of them I get a #VALUE! error saying that a value used in the fornula is of the wrong datatype.

Alll columns are formatted as numbers with 3 decimal places.

Has this happened to anyone else?