adding vlookup values from 2 table arrays

[bduprey]

I am struggling with trying to add together two vlookup formulas from two different table arrays. I have searched the web but not really finding my resolution.

I have attached a file I am working with. I have highlight the two table arrays on the CheckInfo worksheet. The yellow highlighted array is called TaxInfo. The green is MiscDeducts. I need to lookup the value in column 7 in the TaxInfo table and add it to the value in column 2 in the MiscDeducts table. This needs to be store in cell W77 on the Payroll Form worksheet.

My two vlookup formulas are: if($j57="",0,vlookup($j57,TaxInfo,7,False))
if($j57="",0,vlookup($j57,MiscDeducts,2,False))

Note: this is stored in W77 on the Payroll Form worksheet so J57 refers to the Employee Name. Also, this is sample data and I didn't clear the #REF! errors, but they don't factor into this question.

Thanks in advance for the help

[ConneXionLost]

I can't seem to open your sample file, but how about this:

if($j57="",0,vlookup($j57,TaxInfo,7,False)+vlookup($j57,MiscDeducts,2,False))

Cheers,

[JeteMc]

I was able to open the sample file and @ConneXionLost's formula seems to work fine.