VLookup and Hlookup combined using separate workbooks

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!

hi,

is it not possible to link the 2 workbooks then use the lookups

or export the data in via a query then do a lookup

steve

thank you steve for your help... here is another question

=[gradebook.xls]Sheet1!$a$1

is the current generic function that I am using...
I went ahead and copied and pasted the gradebook table into the client file book as a separate worksheet... What I am now doing is having each individual cell automatically go out and reference the other workbook (gradebook). This will either be extremely tedious, OR is there a way to autofill the function through each cell... I have attempted the fill handle but that copies the exact function from one cell to the next, instead of progressing to =[gradebook.xls]Sheet1!$a$2 or =[gradebook.xls]Sheet1!$b$1 as examples...Can this be done? or am I stuck being the lowly intern having to copy and paste/edit each function for a progressively growing clientelle base....

TIA

The dollar signs lock the cell value in place when you drag it. If you remove them, when you drag, the values will change in a relative way.

ChemistB

thank you much mr chemistb!