Thanks Richard but this won't work either, I can't specify an array with cell
numbers because the number of rows will change from report to report and it
can be in the thousands and i don't know where the reporting dist # will be
in column d, the array will have to be $D:$E. But it doesn't work. It's
picking up the first name in column E. I had false as a parameter which means
the list does not need to be sorted but i don't think it wants to work. I've
seen other ways in this forum by using INDEX and MATCH, but I don't
understand the posts or how these 2 functions work together so I haven't been
able to use that either.

Any other help you can provide will be appreciated. Thanks!
--
Hile


"Richard Buttrey" wrote:

On Mon, 3 Jul 2006 11:36:01 -0700, hile trotman
wrote:

AP,
I tried the formula you suggested in this post, but it's not working for me.
I have the following values:
C D E
"Rptg
Dist" Dist District Name

6218 224 WEST CHICAGO
6218 224 WEST CHICAGO
6218 224 WEST CHICAGO
6218 224 WEST CHICAGO
6218 6218 ROMEOVILLE
6218 6218 ROMEOVILLE
6218 6218 ROMEOVILLE

I need to look up the value under "reporting dist" which will always be the
same value for the whole list, in the "dist" column (which will have several
"unsorted" values), when it finds a match, I want it to return the name of
that district which will be under "Dist Name" column. The column headings
start on row7 and row 8 is left blank for using the autofilter command, data
starts on row 9 and the length of the list varies. So the answer for this ex
should be "Romeoville" in cell H3

I have to post this today and this is the only thing keeping me from
finishing this sheet. Please help! Thanks!


=VLOOKUP($A$9,$B$9:$C$100,2,FALSE)

HTH


__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________