Thread: VLOOKUP
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
FP Novice FP Novice is offline
external usenet poster
 
Posts: 55
Default VLOOKUP

I am using some lookup functions in multiple cells of a spreadsheet.
Depending on the search a cell may actually have a null value. When a null
value is returned the cell is populated with a '0'. My question is how do I
make it so a null value is simply an empty cell?

Thank you,
Todd