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!
--
Hile


"Ardus Petus" wrote:

=INDEX(B3:B8,MATCH(B13,D3:D8,0))

HTH
--
AP

a écrit dans le message de news:
...
I have a sheet with 5 colums,

A B C D 1
B C D E 2
C D E F 3

What I want is, using the vlookup function to right!
So the numbers are the lookup value

=VLOOKUP(B13,B3:G8,-2,FALSE)

If I use this, I get an error.

Who can help me???

Greets