Hi, I'm trying to add the ISNA formula to a long formula with 12 IF statements in it. I have a spreadsheet that needs to look into different places based on the account name listed. It works fine, but I need to get rid of the #N/A in order for my pivot table to work. When I've tried doing it myself, I either get a message saying I'm missing a parenthasis or that it's invalid. Here is what the formula looks like now.
=IF($C2="TOTAL SALES AND REVENUES",(VLOOKUP($A2,Forecast!$1:$15000,105,FALSE)),IF($C2="TOTAL FIELD CON",(VLOOKUP($A2,Forecast!$1:$15000,117,FALSE)),IF($C2="TOTAL DIVISION OVERHEAD",(VLOOKUP($A2,Query2!$1:$1048576,75,FALSE)),IF($C2="FRINGE / INSURANCE INCOME",(VLOOKUP($A2,Query2!$1:$1048576,51,FALSE)),IF($C2="TOTAL OTHER INCOME",(VLOOKUP($A2,Query2!$1:$1048576,63,FALSE)),IF($C2="TOTAL GROSS PROFIT",(VLOOKUP($A2,Query2!$1:$1048576,69,FALSE)),IF($C2="TOTAL PRODUCT COST",(VLOOKUP($A2,Query2!$1:$1048576,9,FALSE)),IF($C2="TOTAL CONTROLLABLE COST",(VLOOKUP($A2,Query2!$1:$1048576,27,FALSE)),IF($C2="TOTAL NON-CONTROLLABLE COST",(VLOOKUP($A2,Query2!$1:$1048576,33,FALSE)),IF($C2="PURCHASING INCOME",(VLOOKUP($A2,Query2!$1:$1048576,45,FALSE)),IF($C2="TOTAL ADMIN. LABOR",(VLOOKUP($A2,Query2!$1:$1048576,15,FALSE)),IF($C2="TOTAL REGULAR / HOURLY LABOR",(VLOOKUP($A2,Query2!$1:$1048576,21,FALSE))))))))))))))
Any ideas? Thanks!!
Bookmarks