View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Whats wrong with this formula

Hi,

It looks fine to me and tests out OK.

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"oldjay" wrote:

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

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