VLOOKUP Issue???

[Desperate]

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!!

 

[Pete_UK]

Do it like this:

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

Hope this helps.

Pete

 

[John C]

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

 

[Desperate]

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

 

[Pete_UK]

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

Thanks for feeding back.

Pete

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

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 -