LOOKUP Formula
 

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)

LOOKUP Formula
 

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)

LOOKUP Formula
 

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)

LOOKUP Formula
 

=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)

LOOKUP Formula
 

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)

LOOKUP Formula
 

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)

LOOKUP Formula
 

I don't understand. If this is your formula:

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

C10 is your data validation drop down list, right?

--
Biff
Microsoft Excel MVP


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

LOOKUP Formula
 

Would you by chance be able to take a look at this? Maybe I'm doing
something else wrong. Thanks

"T. Valko" wrote:

I don't understand. If this is your formula:

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

C10 is your data validation drop down list, right?

--
Biff
Microsoft Excel MVP


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

LOOKUP Formula
 

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)

LOOKUP Formula
 

How big is the file? Judging from the formula it looks pretty big.

--
Biff
Microsoft Excel MVP


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

LOOKUP Formula
 

2.08 MB (2,191,360 bytes)

"T. Valko" wrote:

How big is the file? Judging from the formula it looks pretty big.

--
Biff
Microsoft Excel MVP


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

LOOKUP Formula
 

Alright, that's not too big but zip it (compress it) anyhow. My email has
problems with big files. I'm at:

xl can help at comcast period net

Remove "can" and change the obvious.

Include a detailed explanation of what you're tying to do.

--
Biff
Microsoft Excel MVP


"Kimo" wrote in message
...
2.08 MB (2,191,360 bytes)

"T. Valko" wrote:

How big is the file? Judging from the formula it looks pretty big.

--
Biff
Microsoft Excel MVP


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

LOOKUP Formula
 

BTW, I'm using Excel 2002. So if your file is in Excel 2007 format you'll
have to convert it to the xls format.

--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
Alright, that's not too big but zip it (compress it) anyhow. My email has
problems with big files. I'm at:

xl can help at comcast period net

Remove "can" and change the obvious.

Include a detailed explanation of what you're tying to do.

--
Biff
Microsoft Excel MVP


"Kimo" wrote in message
...
2.08 MB (2,191,360 bytes)

"T. Valko" wrote:

How big is the file? Judging from the formula it looks pretty big.

--
Biff
Microsoft Excel MVP


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

LOOKUP Formula
 

Thanks sent it and zipped it.

"T. Valko" wrote:

Alright, that's not too big but zip it (compress it) anyhow. My email has
problems with big files. I'm at:

xl can help at comcast period net

Remove "can" and change the obvious.

Include a detailed explanation of what you're tying to do.

--
Biff
Microsoft Excel MVP


"Kimo" wrote in message
...
2.08 MB (2,191,360 bytes)

"T. Valko" wrote:

How big is the file? Judging from the formula it looks pretty big.

--
Biff
Microsoft Excel MVP


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

LOOKUP Formula
 

Hey Biff just wanted to say thanks for all your help.

"T. Valko" wrote:

How big is the file? Judging from the formula it looks pretty big.

--
Biff
Microsoft Excel MVP


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

LOOKUP Formula
 

You're welcome. Thanks for feeding back to the thread.

--
Biff
Microsoft Excel MVP


"Kimo" wrote in message
...
Hey Biff just wanted to say thanks for all your help.

"T. Valko" wrote:

How big is the file? Judging from the formula it looks pretty big.

--
Biff
Microsoft Excel MVP


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