Vlookup with conditions

**MarkD24** · 07-26-2011, 11:24 AM

I would like to create a formula that performs a vlookup using ISNA to return zero for those conditions and then apply a conditional calculation to that returned answer but am having difficulty constructing it. I'm fine with the vlookup function, but then when I get that answer I'm not sure how to apply the remaining conditions. For example, if there is an amount in column D, then I'd like to divide that by 12 and spread to months. Likewise if there is an amount in column E, I'd like to take the previous vlookup answer and multiply it by this cell. Any suggestions on the best way to do this?

Thanks much for any assistance!
Mark

**Paul** · 07-26-2011, 05:05 PM

Hi Mark, welcome to the forum.

In your sample workbook, might I suggest you add some data to columns D and E and show manually what the values in columns G:I should be. Explain how you arrived at those values.