In your second workbook (the one with the table), can you insert a new
column C and join the two items of data together like this:

=A2&B2

assuming the lookup values are in columns A and B ?

If so, then you could have a formula like:

=VLOOKUP(A1&B1,'path[filename.xls]sheet1'!$C$2:$F$1000,3,0)

Hope this helps.

Pete

On Mar 28, 5:33*pm, Brad wrote:
Okay, I need a way to compare two cells in one workbook to two columns in
another workbook. *When I find those two cells that match exactly then I need
to return a value in another column.

I figure it is some kind of an expanded Vlookup. *This is what I've come up
with so far, but I can't figure out how to make it work.

=VLOOKUP(A1:B2,'[workbook]worksheet1'!$A$2:$E$1000,4,FALSE)