Vlookup, Index & Match

[Phyllis]

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

 

[Guest]

duh, I just figured out what I was doing wrong. I should
have included the ssn in my match. Sometimes I guess you
just need to talk things out to figure them out.

However, I do have one more dilemma. the column for
Seniority code on sheet 2 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 1 could be any number. I need to
look at the code on sheet 1 (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.