P
pierre
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 ??
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 ??