formula not calculating correctly off and on

[topswim]

Afternoon, I perform a lot of Vlookups but sometimes I run into a problem where it's not working correctly and I do not understand why. To make it easy I have added the images so you can see exactly what I'm doing.

The first image is where my formula is in the second is where I'm pulling the information from

These are both in the same workbook, just on different sheets.

=VLOOKUP(O2,'VF Recon from Ron 10-6'!A:R,16,FALSE),

this should pull the value from P 48

 

[Joe4]

So, you are matching on column A, right?
See how one of the entries has a green triangle in the upper corner?
This usually means that the entry is text. So you may have a mixture of numeric and text entries (numbers entered as text).

In order for VLOOKUP to work, you can only compare fields of the same data type, meaning you can only compare numbers-to-numbers or text-to-text.
Comparing numbers-to-text will NOT work.

So you need to make sure that all your data is of the same data type.
You can easily check any value with the ISNUMBER function, i.e. if

=ISNUMBER(A2)

returns FALSE, it means A2 is entered as text, and not as a number.

 

[topswim]

So, you are matching on column A, right?
See how one of the entries has a green triangle in the upper corner?
This usually means that the entry is text. So you may have a mixture of numeric and text entries (numbers entered as text).

In order for VLOOKUP to work, you can only compare fields of the same data type, meaning you can only compare numbers-to-numbers or text-to-text.
Comparing numbers-to-text will NOT work.

So you need to make sure that all your data is of the same data type.
You can easily check any value with the ISNUMBER function, i.e. if

=ISNUMBER(A2)

returns FALSE, it means A2 is entered as text, and not as a number.

Thank you. I thought I did that once, but tried again and it worked.

 

[Joe4]

You are welcome.