I was able to figure out the answer to my first
post "Vlookup, Index, Match" (see below) however, I do
have one more dilemma. the column for Seniority code on
sheet 1 will not be an exact match. I need it to match if
the number meets certain criteria. For example the
seniority code on sheet 1 could be 24, 27 or 28 and the
code on sheet 2 could be any number. I need to look at
the code on sheet 2 (lets say it's 25 for example) and
tell it to match 24 if the code is 24 or less, match 27 if
the code is 25 to 27, and match 28 if the code is 28 or
higher. Now I know I'll never figure this one out on my
own. Any help you can provide is very much appreciated.

-----Original Message-----
Is it possible to combine vlookup with the index and
match
functions? Since the Index & Match are array formulas, I
don't think it's possible to combine it with vlookup.
Here's my dilemma:

Sheet 1
A B C D
JobCode1 JobCode2 Union Local Seniority Code

Sheet 2
A B C D
SSN JobCode2 Union Local Seniority Code

Sheet 3
A
ssn

What I'm trying to do in Cell b1 of sheet 3 is lookup the
ssn in a1 and match it to the ssn on sheet 2. When it
finds a match then match JobCode2, Union Local &
Seniority
Code on Sheet2 to the same on sheet1, then return
JobCode1.

I hope this make sense. I was able to do an array formula
using index and match to match JobCode2, Union Local &
Seniority Code to return JobCode1, but cannot figure out
how do it based on the ssn.

Any suggestions?

thanks
phyllis