Thread: How do I write a VLOOKUP function that returns 0's, not neg vals?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dbsavoy dbsavoy is offline
external usenet poster
  
Posts: 10
Default How do I write a VLOOKUP function that returns 0's, not neg vals?
I need to write a VLOOKUP function that will return a value of "0" if it
finds the number for which it had searched is negative. My thought is to use
an IF logic function together with the VLOOKUP, but I just can't seem to
successfully weave the two together.

Any help would be much appreciated. Thanks!
Reply With QuoteReply With Quote