vlookup help

[Greg Remaly]

I'm trying to change how vlookup returns a value of #N/A. I would rather it
just stay blank. I was thinking of some kind of if then statement, but as I
tried creating something I realized I was probably barking up the wrong
tree. Any ideas? Thanks in advance.

Greg Remaly
(e-mail address removed)

 

[Peo Sjoblom]

One way

=IF(ISNA(MATCH(A1,B1:B100,0)),"",VLOOKUP(A1,B1:C100,2,0))

adapt to fit

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Michael Malinsky]

=IF(ISNA(VLOOKUP(A1,B1:B10,FALSE)),"",VLOOKUP(A1,B1:B10,FALSE))

--
Michael J. Malinsky
Pittsburgh, PA

"I am a bear of very little brain, and long
words bother me." -- AA Milne, Winnie the Pooh

 

[Greg Remaly]

Thanks so much, this worked!!!

=IF(ISNA(VLOOKUP(A1,B1:B10,FALSE)),"",VLOOKUP(A1,B1:B10,FALSE))

--
Michael J. Malinsky
Pittsburgh, PA

"I am a bear of very little brain, and long
words bother me." -- AA Milne, Winnie the Pooh

rather as