use of vlookup result in if statement

[saba]

I have to prepare cash budget with months in a clolumn and credit sale in other.
in budget section i want to show against each month the amount received from credit sale while it is received as
20% in first month
30% in second month
50% in third month
of sale
what i was doing is that i am using if statement and vlookup in it.i want that if m enable to lookup the data then as other argument some calculation to be performed on it.but don't know how to refer to result of data

 

[bensonsearch]

I have to prepare cash budget with months in a clolumn and credit sale in other.
in budget section i want to show against each month the amount received from credit sale while it is received as
20% in first month
30% in second month
50% in third month
of sale
what i was doing is that i am using if statement and vlookup in it.i want that if m enable to lookup the data then as other argument some calculation to be performed on it.but don't know how to refer to result of data

Hi,
As far as i know can in vba by setting vlookup value to a variable but if you did this in a formula you would have a circular and it would die.

maybe use 2 cells with formulas? one looks up the vlookup with your if statement then the one below it calculates what u need from that cell?

eg:

A1:  =if vlookup something
A2: = A1 * 2