VLookUp Formula Will Not Always Work

[d3a4n]

=IF(B2="","",VLOOKUP(B2,CompleteInventory!A:E,5))

I am using the above formula to pull a part description off the
CompleteInventory page for the value in B2. The value of that cell
appears to be fine when I first use it but after a few minutes the
formula doesn't seem to work.

It will pull a value from an incorrect cell.

No matter what I put in the B2 cell it will return the wrong cell
contents out of 800 different part numbers.

Any Ideas?

 

[Jerry W. Lewis]

See Help for VLOOKUP. As entered, your formula assumes that
CompleteInventory!A:A is sorted in ascending order. If it finds a value
in CompleteInventory!A:A that is greater than B2 before it finds an
exact match, then it will return the value from the row before that
value. To return an exact match without assuming an ascending sort
order, you would use
=IF(B2="","",VLOOKUP(B2,CompleteInventory!A:E,5,FALSE))

Jerry