How do I use Vlookup to compare these numbers

Closed
Tonya - May 17, 2012 at 07:46 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 22, 2012 at 09:02 AM
Hello,

I don't know how to use Vlookup and I need to compare these two sources of data. Could some please help me with results? Thank you soooo much in advance.

Fail 250 5.00%
Fail/Failed to retrieve a unique identity 293 5.86%
Pending 4449 88.98%
Unable To Generate/Could not generate enough questions. 8 0.16%


Compare to these field:

Fail 184 3.68%
Fail/Failed to retrieve a unique identity 293 5.86%
Pending 4515 90.30%
Unable To Generate/Could not generate enough questions. 8 0.16%






1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
May 22, 2012 at 09:02 AM
Hi Tonya,

VLOOKUP is used to pull specified information from a table/matrix.

What do you want to achieve from the comparison?
Would you like to know which lines are different from each other?

Best regards,
Trowa