I have finally hit a brick wall! I am trying to integrate two separate files, one a gradebook and the other a client file that will record grades given that are placed within the workbook.

What i am hoping is to find a formula/function that would be able to take the client name, do a vlookup within another workbook, then do a hlookup to find the appropriate assignment and grade.

I noticed the other thread just a few down describing how to do such an act within the same workbook/worksheets, but is it possible to branch out to another workbook?

any help will be much appreciated, and if anymore imformation that may be needed do not hesitate to ask! TIA!

btw: i have to say that after lurking for a lil bit, I have realized that excelforum.com is quite the reference tool! Already have it bookmarked!