Compare Two Ranges

Hi, i've google this quite a bit and nothing,

Im trying to do the following compare a criteria to a range if they are equal that the answer instead of been true that the answer will be Tier X

Can that be done? Im attaching a sample of the excel file.

in summary im trying to find a formula that can compare the job title column (B2) from Sheet (User Name) to Sheet (Tier Job Titles) Column A and Column B and if they are equal to put on sheet user name on column D what number of tier the person belongs to.

The Formula for D

=IF(B3='Tier Job Titles'!A3:A8,'Tier Job Titles'!B3:B8,"")

Assuming that I am understanding you correctly

Sorry it should be something a little more like this:
=LOOKUP(B3,'Tier Job Titles'!A3:A8,'Tier Job Titles'!B3:B8)

try =VLOOKUP(B3,'Tier Job Titles'!$A$3:$A$8,2,false)

Originally Posted by Stupidav

The Formula for D

=IF(B3='Tier Job Titles'!A3:A8,'Tier Job Titles'!B3:B8,"")

Assuming that I am understanding you correctly

Hello Stupidav, it work but once i sort out the columns the results changes, i also tried the last two other formulas and none seem to work, the second one gave a different result and the third comes out with an error.

Any other ideas? please?

Ooops, typo
=VLOOKUP(B3,'Tier Job Titles'!$A$3:$b$8,2,false)

Originally Posted by arthurbr

Ooops, typo
=VLOOKUP(B3,'Tier Job Titles'!$A$3:$b$8,2,false)

Thank you so much, your a genius or maybe im just to dumb but it worked. thank you