use a vlookup value in a table

This is what I want to do
formula to go in cell K12
Find the cell in the range C11:C93 that corresponds to the number to the left of this cell (J12) and add the value one column to the right of that matching value to the value in K11
Add K11 (cell above)

photo of the sheet here to give you context.
https://drive.google.com/open?id=0B0...DM4VlZ1RzRNd1U

Previously it worked with this
=IF((K11-$N$7)*(1+$F$7)<=0,0,(K11-$N$7)*(1+$F$7))+P12

I want it to do almost the same thing I just want to add a value from the table next to the one this cell is in.

I'm sorry - I opened your file and my eyes started boggling, inducing a headache. Can you provide a simplified version with JUST the tables in question?

Thanks.

It might also be an idea to tell us what sheet we're meant to be trying to look at...

Originally Posted by JohnTopley

K10 has text "Capital" and K9 is blank???

Oh I see what happened. The spreadsheet I uploaded and the photo are from two different versions of the workbook.

I fixed the link to the photo so now the workbook and the photo of the sheet I need help with are a match. Sorry about the screw up.

so the expected answer in K11 is what????

K11 won't be changed it will stay the same
K12 is the cell the new formula will be in.
The solution will be ((((K11+D39)+P12)-$N$6)+L12))
to be exact.

The part I need help with is the D39 part
That's what I need the lookup for but I'm not sure syntax wise how to set it up exactly

K11 is last year's balance
D39 is the current year deposit if there is one that corresponds to the age to the left of K12
So the lookup will take the age listed in J12 and find the corresponding value in the range C11:C93 and get the value in the first column to the right of that
P12 is the Current year's fees as a negative value that's why the fees are added
$N$6 is the Current year's withdrawal
L12 is the current year's growth

Oops there's some other stuff I almost forgot about
I still need it to do what it was before so I need it to do all that
IF((K11-$N$6)<=0,0,

So I need it to do a check first if last year's balance minus this year's withdrawal is less than or equal to zero
so I guess it'll look something like this

IF((K11-$N$6)<=0,0,
and after that the else condition
((((K11+D39)+P12)-$N$6)+L12))

Again I'm not sure syntax wise how to build it or the D39 lookup

Thanks for the help