Querying Between Workbooks

[DonP]

I hope someone can help as I do not know Excel's special features well, and I do not know VBA at all (I presume this is a VBA issue).

I have a spreadsheet with two workbooks, one having a list of people who have taken a class; the other of all employees. I need to compare between them to see those who have not taken the class. I also need to generate a percentage of those who have taken it. There is a column, UID, that is common between them for comparison purposes. This needs to be easily runable by someone with even less Excel experience than I! How can this be done? I don't even know where to begin! Thanks in advance.

Don

http://www.pc-homepage.com/

http://www.personalzone.net/

Experienced in HTML, Perl, PHP, VBScript, PWS, IIS and Apache and MS-Access, MS-SQL, MySQL databases

 

[arthurbr]

Did you have a look at the vlookup function?

 

[DonP]

Thanks, no I haven't but I'll take a look. I don't know Excel well enough to have ever used any functions. How or where are functions run?

Don

http://www.pc-homepage.com/

http://www.personalzone.net/

Experienced in HTML, Perl, PHP, VBScript, PWS, IIS and Apache and MS-Access, MS-SQL, MySQL databases

 

[arthurbr]

In all XL versions you will find a button callesd "fx". Just press it, look for the Lookup and refernce functions and choose "vlookup".
Follow the wizard and you will have your solution.
Don't forget to eventually change the lookup table to absolute references as needed.

 

[DonP]

Thanks, found fx (so obvious yet I missed it before!) but I couldn't make much sense of vlookup. The best I got was a circular reference error. In the end, this needs to be runable by anyone with the press of a button, so to speak, so is there a way to do that using the built-in functions or is something more complex required?

Can SQL-like queries be run in Excel? I know SQL fairly well so maybe I can do something that way.

Don

http://www.pc-homepage.com/

http://www.personalzone.net/

Experienced in HTML, Perl, PHP, VBScript, PWS, IIS and Apache and MS-Access, MS-SQL, MySQL databases