VLOOKUP

  • Thread starter Thread starter George Gee
  • Start date Start date
G

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
 
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 *
 
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:
 
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 *
 
Back
Top