I'm using the VLOOKUP function to return data from a named range which
contains several data points (across the row) for several "sites" which are
numbered down the left in column A: 26e, 28e,...64e,64w,62w,60w... etc.

SAMPLE:

Row/Sec. 1 2 3 4 5...
Profile Depth (cm) 0.5 10.5 20.5 30.5 40.5...
26e 1.639885 21.143383 30.020775 27.024311 24.509054...
-2.5 7.5 17.5 27.5 37.5...
28e 15.430596 21.295532 25.333948 30.626244...
1 11 21 31 41...
30e 0.393868 10.764123 19.071701 15.003836 11.230032...
6.5 16.5 26.5 36.5...
32e 23.005785 21.448273 22.900213 19.946169...


The code I am using in another area of the sheet to return these numbers and
perform averages on them is:

=VLOOKUP("26e",profiledataeast,2,TRUE)

where profile dataeast is the named range for the top half of the range that
contains data for all east locations and data for the west locations is in
the bottom half of the range and I lookup the data with:

=VLOOKUP("26w",profiledatawest,2,TRUE)

The trouble I am having is, regardless of the designation "e" or "w" in my
alphanumeric lookup column on the left, Excel is returning the same data
(from the top half "e") to the right for both entries in the column that
contain a given number . This can be seen where the new data is displayed
after VLOOKUP gets it from "64e" and "64w":

64e 2.087324 19.023703 17.246429 13.043617 16.659203 21.909708
64w 2.087324 19.023703 17.246429 13.043617 16.659203 21.909708

The data returned is data from 64e, but gets returned for
=VLOOKUP("64w",profiledatawest,2,TRUE) too!

What am I overlooking?