Hi there,

I have tried both yours and Valko's formulas and for some reason or another
neither is working. I guess I am doing something wrong. Is there a
possibility I could email this spreadsheet to you. It's a worksheet that I
am trying to develop for work since we do everything maual at the moment. Or
if there is anyone out there that can take a look at it, I would greatly
appreciate it. Thanks Kimo

"Teethless mama" wrote:

=IF(C10=0,0,IF(ISNA(VLOOKUP(C10,cdm1107!A3:H11480, 8,0)),"",VLOOKUP(C10,cdm1107!A3:H11480,8,0))


"Kimo" wrote:

Hope there is someone that can help me out. I have tried everything I have
read on eliminating #N/A to appear. I've tried the =IF(ISNA(myformula),"",my
formula). Basically my formula reads like this. It's looking up Prices and
I'm trying to get a return of "$0.00".

If my service code number = 000000000 I need the unit price to remain at
$0.00 I hope this makes sense to someone. Thanks in advance

=LOOKUP(C10,cdm1107!A3:A11480,cdm1107!H3:H11480)