Thread: #N/A Error for IF Statement With VLOOKUP Formula

I need help with a formula. I'm getting an #N/A error for the following formula: =IF($D$17=0,0,VLOOKUP($D$17,C20:F22,4,0)) This has me baffled. I attached the spreadsheet for review. I put arrows and notes on the sheet for quick identification of the issue. Let me give you a run down of the problem: when you put the flat polish price in. That price matches the lookup table and the Fab Prices table, but it’s giving an error.

For example: If you look at the sheet I attached. Then set the mark up to 3. The left column of the lookup table should be .06, .15, and .12. If you enter .06 in the Flat Polish box the formula works. If you enter .15 in the Flat Polish box the formula doesn’t work. If you change the mark up and enter in the corresponding Flat Polish rate then you may have all three work or you may not.

I really appreciate any help given as I have no idea how to correct it.

From Excel help on VLOOKUP "...The values in the first column of table_array are the values searched by lookup_value. These values can be text, numbers, or logical values. ..." A formula (=T11) is not one of these values.

Do you have any suggestions on how to make this work. Most all the cells in the spreadsheet have a formula. I'm lost , but if someone can point me in the right direction I can fix it.

Awesome!! It works! Thank you very much!! I really appreciate your help. I knew it had to be something simple, but had no idea.