#N/A help please

C

cadustin

I have tried to correct this formula with the ISNA, and not getting any
result, please fix what I am doing wrong! I put the ISNA in the beginning and
am getting an error. I just want excel to return either a blank cell or a 0
if nothing has been entered. My formula works great other than the #N/A when
nothing is in my other fields to produce my formula.

=IF(ISNA($F$2="FMLA",INDEX('R:\Benefits\[Insurance Premiums for
leaves.xls]Look Up Sheet'!$B$6:$E$9,MATCH(B6,'R:\Benefits\[Insurance Premiums
for leaves.xls]Look Up Sheet'!$A$6:$A$9,0),MATCH(A6,'R:\Benefits\[Insurance
Premiums for leaves.xls]Look Up
Sheet'!$B$1:$E$1,0)),INDEX('R:\Benefits\[Insurance Premiums for
leaves.xls]Look Up Sheet'!$B$2:$E$5,MATCH(B6,'R:\Benefits\[Insurance Premiums
for leaves.xls]Look Up Sheet'!$A$2:$A$5,0),MATCH(A6,'R:\Benefits\[Insurance
Premiums for leaves.xls]Look Up Sheet'!$B$1:$E$1,0))))
 
D

Duke Carey

maybe:

=IF($F$2="FMLA",IF(ISNA([your lengthy formula]),"",[your lengthy formula]),"")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

combine vlookup and match help 6
Possibly an IF function? 1
Function that will look at letter in a column and return a number 3
IF INDEX and MATCH function together 7
SET UP FORMULAS AND CODE TO WORK WHEREVER WKB IS USED 2
IF ARRAY with multiple conditions. 1
Index and Match 8
Lookup functions always return n/a ??? 3

Top