Lookup/Filter

[Chris]

I import data into excel from an .ap file and then do a
vlookup from another page to find that imported data. My
problem is that the .ap file I am importing from has the
data in a different form than I need it. I am dealing
with radio stations so all is based on their call
letters. The .ap file has the stations listed as WXYZ-FM,
but I need to have the -FM eliminated because my lists
only have WXYZ. If I manually do the left fuction to
eliminate the -FM then when I do the Vlookup from the
other page it won't be for the entire range "filename.ap"
it will instead be range "A2:O12" for example. I want to
set this up so that it can be somewhat automated where I
can refresh the data and won't have to keep redoing the
vlookup to include the data range in the event that there
are more radio stations in my imported data (which is
usually the case).

The data looks like this:

Station Reporter TW LW 2W
WXYZ-FM 1 2 6 4
WXYZ-FM 0 3 2 7
WXYZ-FM 1 0 3 1

I need the same exact thing minus the -FM that I can use
to do a vlookup on, where the vlookup will recognize the
entire data range for the lookup and expand and contract
accordingly with the new data from week to week.

If this isn't clear please contact me.
(e-mail address removed)

Thanks in advance for your time.

 

[Frank Kabel]

Hi Chris
one way would be to change the VLOOKUP function as follows:
=VLOOKUP(A1 & "-FM",lookup_range,lookup_row,FALSE)
where A1 stores your lookup value (that is the radio station)

HTH
Frank