Vlookup problem

D

Debbie

Hi!

The problem I am having is in the lookup table, sometimes row 5 is
empty. When it is, it puts a zero in my cell. I want it to be blank.
Can I do this? I have pasted my formula.

=IF(ISERROR(VLOOKUP($A7,BB!$A$1:$S$5000,5,FALSE)),"",VLOOKUP($A7,BB!$A
$1:$S$5000,5,FALSE))
 
D

Debbie

Hi!

The problem I am having is in the lookup table, sometimes row 5 is
empty. When it is, it puts a zero in my cell. I want it to be blank.
Can I do this? I have pasted my formula.

=IF(ISERROR(VLOOKUP($A7,BB!$A$1:$S$5000,5,FALSE)),"",VLOOKUP($A7,BB!$A
$1:$S$5000,5,FALSE))

Sorry, column 5 not row 5
 
P

Pete_UK

Well, it's a bit messy, but you could do this:

=IF(ISERROR(VLOOKUP($A7,BB!$A$1:$S$5000,5,0)),"",IF(VLOOKUP($A7,BB!$A
$1:$S$5000,5,0)="","",VLOOKUP($A7,BB!$A$1:$S$5000,5,0)))

Hope this helps.

Pete
 
T

T. Valko

What is the data type of the returned value?

If it's TEXT try this:

=IF(ISERROR(VLOOKUP($A7,BB!$A$1:$S$5000,5,0)),"",T(VLOOKUP($A7,BB!$A
$1:$S$5000,5,0)))

If it's numeric will 0 be an otherwise valid result?
 
J

Jacob Skaria

'if col 5 is text then you can tr
=IF(ISERROR(VLOOKUP($A7,bb!$A$1:$S$5000,5,FALSE)),"",T(VLOOKUP($A7,bb!$A$1:$S$5000,5,FALSE)))

'or other wis
=IF(ISERROR(VLOOKUP($A7,bb!$A$1:$S$5000,5,FALSE)),"",IF(VLOOKUP($A7,bb!$A$1:$S$5000,5,FALSE)="","",VLOOKUP($A7,bb!$A$1:$S$5000,5,FALSE)))


If this post helps click Yes
 
D

Debbie

'if col 5 is text then you can try
=IF(ISERROR(VLOOKUP($A7,bb!$A$1:$S$5000,5,FALSE)),"",T(VLOOKUP($A7,bb!$A$1:­$S$5000,5,FALSE)))

'or other wise
=IF(ISERROR(VLOOKUP($A7,bb!$A$1:$S$5000,5,FALSE)),"",IF(VLOOKUP($A7,bb!$A$1­:$S$5000,5,FALSE)="","",VLOOKUP($A7,bb!$A$1:$S$5000,5,FALSE)))

If this post helps click Yes
---------------
Jacob Skaria







- Show quoted text -

Thank you. The second works great.
 

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

Top