vlookup
 

i have prepared the following data for VLOOKUp

A B
1 debit 4619
2 credit 4619


the wanted results i want in column C:

A B C
1 debit 4619 + D1 's value
2 credit 4619 - D1 ' s value


i mean that if enter for example in cell A5 and beyond : "debit" and in
cell B5 and beyond : "4619" , i should be getting column's D values in
column C
how to do that ?? or any suggestion other than vlookup ??