How do I use Vlookup to compare these numbers

Closed
Tonya - 17 May 2012 à 07:46
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 22 May 2012 à 09:02
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 12 September 2010 Status Contributor Last seen 27 December 2022 555
22 May 2012 à 09:02
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