if,isna and vlookup formula - need help for my project

[crunchtime9999]

Greetings,
I keep getting a message saying there is an error with my formula and it highlights the 0. Can someone please help me to fix this.

=IF(ISNA(VLOOKUP(CONCATENATE($A2,"EA"),Pricing!$P:$R,3,FALSE),0,VLOOKUP(CONCATENATE($A2,"EA"),Pricing!$P:$R,3,FALSE)))

What I am doing is doing a vlookup on a product is concatenated with the word ea and searching a pricing worksheet for the value. If there is no value I need to return 0 and if there is a value I need to return the value.

Thanks,
I know one of you master can figure this out.

 

[erock24]

I think you need 1 or 2 more ")" after the word "false"

edit:

Just tested it and it looks like it is just 1 more ")" after the 1st "False" before ,0

=IF(ISNA(VLOOKUP(CONCATENATE($A27,"EA"),$A1:$D24,3,FALSE)),0,VLOOKUP(CONCATENATE($A27,"EA"),$A1:$D24,3,FALSE))

 

[barry houdini]

Just a misplaced parenthesis, try

=IF(ISNA(VLOOKUP(CONCATENATE($A2,"EA"),Pricing!$P:$R,3,FALSE)),0,VLOOKUP(CONCATENATE($A2,"EA"),Pricing!$P:$R,3,FALSE))

 

[FlyingKiwi]

You need another ')' to close the isna funcation.

ie =IF(ISNA(VLOOKUP(CONCATENATE($A2,"EA"),Pricing!$P:$R,3,FALSE)),0,VLOOKUP(CONCATENATE($A2,"EA"),Pricing!$P:$R,3,FALSE))

 

[crunchtime9999]

Just a note: I have been checking my email to see if anyone responded and noticed that my spam filter was set to max so if anyone sent a reply can you please resend.

thanks

 

[crunchtime9999]

Wow,
thanks for the quick replies. I will try these.

 

[barry houdini]

Here's an alternative:

=IF(COUNTIF(Pricing!$P$P,$A2&"EA"),VLOOKUP($A2&"EA",Pricing!$P:$R,3,0),0)