Hello,

I am trying to perform a vlookup using the correct formula, and applying it
to a large range of cells in a row. Now, when the vlookup finds the correct
match in the array it returns the correct value [yeah :)], but when there is
no matching value it returns #NA, which affects the whole spreadsheet. Is
there any way I can get it to return a zero instead????

Desperately in need of help!!

Do it like this:

=IF(ISNA(your_vlookup_formula),0,your_vlookup_form ula)

Hope this helps.

Pete

On Jul 31, 4:37*pm, Desperate
wrote:
Hello,

I am trying to perform a vlookup using the correct formula, and applying it
to a large range of cells in a row. Now, when the vlookup finds the correct
match in the array it returns the correct value [yeah :)], but when there is
no matching value it returns #NA, which affects the whole spreadsheet. Is
there any way I can get it to return a zero instead????

Desperately in need of help!!

2 ways....

One is the IFERROR function,

=IFERROR(VLOOKUP(,,,),0,VLOOKUP(,,,))

or you can do a COUNTIF function

=IF(OUNTIF(Data!$A$2:$A$100,A2)=0,0,VLOOKUP(,,,))

Where Data!$A$2:$A$100 is your lookup column of your data set
--
John C


"Desperate" wrote:

Hello,

I am trying to perform a vlookup using the correct formula, and applying it
to a large range of cells in a row. Now, when the vlookup finds the correct
match in the array it returns the correct value [yeah :)], but when there is
no matching value it returns #NA, which affects the whole spreadsheet. Is
there any way I can get it to return a zero instead????

Desperately in need of help!!

Man oh Man you guys are the shiznit, wish I could buy you beers

"Desperate" wrote:

Hello,

I am trying to perform a vlookup using the correct formula, and applying it
to a large range of cells in a row. Now, when the vlookup finds the correct
match in the array it returns the correct value [yeah :)], but when there is
no matching value it returns #NA, which affects the whole spreadsheet. Is
there any way I can get it to return a zero instead????

Desperately in need of help!!

Well, I presume that's a compliment !! <bg

Thanks for feeding back.

Pete

On Jul 31, 5:03*pm, Desperate
wrote:
Man oh Man you guys are the shiznit, wish I could buy you beers



"Desperate" wrote:
Hello,

I am trying to perform a vlookup using the correct formula, and applying it
to a large range of cells in a row. Now, when the vlookup finds the correct
match in the array it returns the correct value [yeah :)], but when there is
no matching value it returns #NA, which affects the whole spreadsheet. Is
there any way I can get it to return a zero instead????

Desperately in need of help!!- Hide quoted text -

- Show quoted text -