View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
khatch5995 khatch5995 is offline
external usenet poster
 
Posts: 1
Default Multiplying a Vlookup result of 0, getting a value error

My spreadsheet has a column that's a Vlookup. Some of the results equal
0.00. I am multiplying that column by another column that may also have a
zero value. Whenever the value in these columns are 0's, the product becomes
a #value! error.
I want the product to be 0. How can I do this? Thanks!
khatch5995