VLOOKUP

[George Gee]

Hi All

I have the following formula:
=IF($D$9="","",VLOOKUP($D$9,List!$A$1:$G$500,7,FALSE))
which works fine.

Problem:
How do I stop the value *0* displaying, if there is no data in
worksheet List! column 7 ?

Many thanks
George

 

[A.W.J. Ales]

George,

=IF($D$9="","",IF(VLOOKUP($D$9,List!$A$1:$G$500,7,FALSE)=0;"";VLOOKUP($D$9,L
ist!$A$1:$G$500,7,FALSE))


--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

 

[George Gee]

A.W.J. Ales

Many thanks, it works, although needed a slight change:

=IF($D$9="","",IF(VLOOKUP($D$9,List!$A$1:$G$500,7,FALSE)=0;"";VLOOKUP($D$9,L
ist!$A$1:$G$500,7,FALSE)))

George




*A.W.J. Ales* has posted this message:

 

[A.W.J. Ales]

YW George and thanks for the feedback.
It's always nice to hear that things worked out.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *