Help with vlookup

G

Glen Mettler

I have data in another sheet that I want to lookup and present in a summary.
The standard vlookup would be something like this:

=Vlookup($A6,MDR!$K4:$S100,9,0)
Here is the problem
If the data exists in MDR, I get it - OK
If the data DOES NOT exist, I get #N/A

I tried these:
=If(Vlookup($A4,MDR!$K4:$S100,9,0)=0,,0,Vlookup($A4,MDR!$K4:$S100,9,0))
=If(Vlookup($A4,MDR!$K4:$S100,9,0)="#N/A",,0,Vlookup($A4,MDR!$K4:$S100,9,0))
- with & without quotes
=If(Vlookup($A4,MDR!$K4:$S100,9,0)=false,,0,Vlookup($A4,MDR!$K4:$S100,9,0))

How can I do this? If the data is found, paste it, otherwise paste 0.

Glen
 
J

JulieD

Hi Glen

use
=IF(ISNA(Vlookup($A6,MDR!$K4:$S100,9,0)),0,Vlookup($A6,MDR!$K4:$S100,9,0))

Cheers
JulieD
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with using vlookup and acting on the results 2
Help with Conditonal Sum 2
Vlookup or Other vs Sort? 1
Use & with two formulas 2
VLookup Function HELP 7
vlookup - can't find match 1
Vlookup and Indirect help!! 2
#REF error with Vlookup 1

Top