View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
confused confused is offline
external usenet poster
 
Posts: 193
Default Vlookup and adding text

How would I write the vlookup formula where, if vlookup formula returns a
number, then I want the number to include "/ month" after it. If the vlookup
does not return a value, then I want to show a blank. For example, my
vlookup formula is vlookup(B2,database,3,false) returns 4,031. I want the
cell to read "4,031 / month" .

any help is much appreciated. Thanks