Building The Isna Function Into My Formula!!!

[bwhizz]

Hi guys,

I am working on this spreadsheet and I am using nested if statements with the vlookup function. The formula I typed in works really well, however when there is no value in the cell that looks up the value in the data spreadsheet it returns a value of N/A.

I know to eliminate this, all you have to do is build in your if statement, IF(ISNA,"",Value if False), but this isn't working out for me.

The formula that is returning a N/A value is

=IF($A$3=300,VLOOKUP(A5,Data!$A$4:$K$125,2,FALSE),IF($A$3=400,VLOOKUP(A5,Data!$A$4:$K$125,2,FALSE),IF($A$3>499,VLOOKUP(A5,Data!$A$4:$K$125,2,FALSE)))

so again, how do I build the ISNA function in this formula?

Thanks!

[bwhizz]

I think I figured out how to do this - but now its telling me I have entered too many arguements. Is there any way to get around this?

All i did at the beginning of the formula was type if(isna,"",(if(vlookup....etc.)

[Stuart Farr]

When you entered the isna part, did you put in the correct closing bracket?

[bwhizz]

Yes I did,

I entered the closing bracket at the end, but then it says I've entered too many arguments....

[bwhizz]

Please Help!

[Dav]

if it is only the value of a5 that causes an error if it is blankyou do not need isna

=if(a5="","",IF($A$3=300,VLOOKUP(A5,Data!$A$4:$K$125,2,FALSE), IF($A$3=400,VLOOKUP(A5,Data!$A$4:$K$125,2,FALSE),I F($A$3>499,VLOOKUP(A5,Data!$A$4:$K$125,2,FALSE))))

should suffice

but you are always looking up the same range in the formula VLOOKUP(A5,Data!$A$4:$K$125,2,FALSE) regardsless of what if is true

the following would return the same

if(a3="","",if($a$3=300,$a$3=400,$a$3>499.VLOOKUP(A5,Data!$A$4:$K$125,2,FALSE),""))

What are you trying to achieve

Regards

Dav