Re: Reference a cell value in a vlookup function

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