Lookup Table to return result if corresponding cell is > 0 (or not blank)

[EssKayKay]

Hello,
This may be quite convoluted – I hope I can explain.

I’m trying to use a lookup table to return an answer. I have some of it working but I have one more parameter I’d like to include.

The lookup table and formula resides in sheet “Escrow”. Most of the data resides in sheet “Amortize”. Because I do not know how to directly address the data in Amortize, I reference Amortize cells in Escrow. Ultimately I’ll try to directly address the data in Amortize but for now I’d just like to see if I can get this working.

Following is a snipit of what I have in mind.

Here is the Lookup Table –

Column/Range B8:B108 in sheet Escrow contains the Lookup Cell.
Here is the formula I have to return my result/answer =VLOOKUP(B12,$N$10:$P$110,2,0)

What I’m looking for is a way in the above formula to only return a result if the value in column P of the lookup table is > 0 or not blank. There is a formula in Column P that return “” if a condition is met: =IF(Amortize!T34>0,Amortize!T34,"").

In this example above, cell B12 = 2028 returns $2,000, which is correct. What I’m looking for is if the lookup cell is B14 (which is 2030) it returns nothing since the corresponding cell in the lookup table Column P (cell P16) is blank.

Thanks for viewing,
Steve K.

 

[EssKayKay]

Thank you all for your time and concern. It appears option Alex's option Post #3 is what I am looking for.
As I noted, I may be back for assistance on referencing a lookup table in a differenet sheet.

Again, so much appreciated from you all. You guys are so helpful and truly valued.
Steve K