Re: Reference a cell value in a vlookup function

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Michelle (anonymous_at_discussions.microsoft.com)
Date: 04/01/04 

Date: Thu, 1 Apr 2004 09:36:11 -0800

I have two columns of data: in column A there are four digit numbers and in column B there are text strings. I come up with the four digit number in cell H11 and am trying to return the text string associated with it. This is the formula I originally used: =VLOOKUP(H11, Segment, 2, FALSE) where Segment = A17:B1312
that returns the error message #N/A

I tried =VLOOKUP(INDIRECT($H$11), Segment, 2, FALSE)
that returns #REF

I dont know if it matters, but the value in H11 is from a CONCATENATE function

Relevant Pages

  • Re: Some good news, a light for Ultuimate
    ... When every player on BBall team A points their way and every player on ... When a wide receiver goes all crazy when the ref calls him out ... i dont hink they do that since they have IR ... compare to freestyle disc juggling or some shit. ...
    (rec.sport.disc)
  • Re: No refs please
    ... if any official (observer or ref) needs input from players to "get the ... new unfairness concern that a ref system raises. ... upa claims to be a leader in the advancement of the sport its only ... you dont seem to be a sports guy period......which is probably why you ...
    (rec.sport.disc)
  • Re: Liga Picks Contest Jornada 36 7 de mayo de 2008
    ... haven't peeked yet - as my inept predictions will doubtless prove. ... so I dont think you need to worry. ... ref: Gonzalez Vazquez ... Can they beat Sevilla for the 1st ...
    (rec.sport.soccer)
  • Re: FOR ALL GUYS THAT LIKE REFERENCING GOLFS SOTG......
    ...  in this case it was the rules and ref that enabled barns to ... basketball that they dont enforce traveling properly ... then why dont they use that system in ALL formal organized comp? ...
    (rec.sport.disc)
  • Re: What micros do you actually hate to work with?
    ... and I have shown you that it IS possible.Indded i dont, you didnt post them but the comparison is self evident. ... in C and that it fits in 1 kB ... 13 bytes in segment ABSOLUTE ...
    (comp.arch.embedded)