Hello All,

I have a series of IF functions that will plot certain phone charge rates. I have the formula based on priority. Here's an idea of what I want to do:

First Step: If the specified cell has 0 as the value, then 0 will be returned

Second Step: If that same specified cell isn't 0, then I have quite a few IF formulas to return a value based on ID numbers in a seperate column.

The third step i'm trying to implement is a VLOOKUP that pulls from a set of data if the specified cell returns neither 0, nor any of the ID Numbers. This will be set as a last resort, but I need it to do a VLOOKUP. I also need this to happen in order. I've added my current working formulas. I need to know if it is possible to combine these 2 formulas. I've attached the spreadsheet, please let me know if this is possible.

This code is in cell N4 of the first tab
=IF(H4=0,0,IF(C4=30285,0.15,IF(E4=5049,0.15,IF(E4=6535,0.99,IF(E4=6539,0.99,IF(E4=6541,0.99,IF(E4=6542,0.99,IF(E4=6544,0.99,IF(E4=44265,0.99,IF(C4=1192,0.99,IF(C4=26401,0.08,IF)))))))))))
This is the code from cell M4 I would like added in the end of the 1st code somehow. It pulls data from the second tab 
=VLOOKUP(D4,AirToll,3,FALSE)
Hopefully this will give you an idea of what i'm trying to do. Please advise if you need me to elaborate anymore.

Thanks in advance for checking this out!


Rate Sample.xlsx