MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Data varaiance


Posted by Kim Powell on October 24, 2001 1:37 PM

I have two spreadsheets which both contain two columns of data - Product Numbers (Alpha-numberical) and Total Sales ($). I would like to compare these spreadsheets and report what the differences between the two are. ie: Variances in the Product Codes or Total Sales.

I have looked at using LOOKUP commands but as the product code fields are Alphanumerical it looks for the next best match if the code does not exist giving me false results.

Any suggestions on ways which I can achieve the desired result.


Posted by Mark W. on October 24, 2001 1:46 PM

VLOOKUP is giving you the "best match" (but, not
necessarily so) because you've either omitted the
4th (optional) argument or supplied either a 1 or
TRUE as that argument. Use 0 or FALSE as the 4th
argument and you'll get an exact match.