On 2002-11-04 16:24, fmaresca wrote:

Not quite sure if I understand your question, but here's the logic I am trying to apply. I am doing a VLOOKUP based on Column A in each sheet. Once I find a match (since both sheets are not arranged in the same order) it goes to the next column (Column B) which finds the quantity (a number/value), that should be subtracted from Column B in the other sheet to arrive at the difference (to reconcile). Since what is in Column B in both sheets are numbers/values, the result should be a value and not #N/A.

Thanks.

If this formula

=VLOOKUP(A183,LPRawData!$A$2:$C$625,2,FALSE)-B183

should return a numeric value from column 2 of LPRawData!$A$2:$C$625 for the value in A183 and it fails to do so (that's, you get #N/A), that means the value in A183 is not in LPRawData!

**$A$2:$A$625**. It could be the case that either the value in A183 or the one in LPRawData!

**$A$2:$A$625** have extraneous characters such spaces around them, that is:

"XYZ3U" is not the same as "XYZ3U ".

Check the length of the lookup value and the one in the lookup table by using LEN...

=LEN(A183)=LEN(LPRawData!x)

where x is the cell the same value as in A183 appears. They should be equal in length.