Well that works but I have validation list for my service code numbers, so if
I try to change the service code number, it doesn't look up the price and
leaves it as zero.

"T. Valko" wrote:

OK, try this:

=IF(C10=0,0,LOOKUP(C10,cdm1107!A3:A11480,cdm1107!H 3:H11480))

I'm trying to get a return of "$0.00".

Format the cell as CURRENCY 2 decimal places

--
Biff
Microsoft Excel MVP


"Kimo" wrote in message
...
It's just a formatted number. My service code number could also be just
"0"
if that would make it easier. Thanks

"T. Valko" wrote:

Is your service code number, 000000000, a TEXT string or is it a custom
formatted number?

--
Biff
Microsoft Excel MVP


"Kimo" wrote in message
...
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)