View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Oldjay Oldjay is offline
external usenet poster
 
Posts: 337
Default Whats wrong with this formula

="Ext. No. "&VLOOKUP(C19,Z71:AB76,3)yields "Value"

=VLOOKUP(C19,Z71:AB76,3) yields the correct result