VLOOKUP, XLOOKUP or INDEX?

[mrstivoaddict]

I am currently using VLOOKUP to return a value from one tab to another.

=VLOOKUP(E2,Rates!$B$3:$C$57,2,0)

I would like to add additional conditions to this formula so that it will look up the values of each cell in column A and B to return the corresponding value from the Rates sheet into column C.
I'm trying to decide what's the best way to do it.

DETAILS

POSITION (A)	TYPE (B)	RATE (C)
MANAGER	ST
SUPERVISOR	OT
WORKER	ST
WORKER	DT
SUPERVISOR	DT
WORKER	DT

RATES

POSITION	ST	OT	DT
MANAGER	172	220	294
SUPERVISOR	169	217	290
WORKER	150	175	200

So...if vlookup finds Manager and ST, it will return 172, Supervisor and DT will return 290, Worker and OT will return 175, etc.

Suggestions would be much appreciated!

 

[mrstivoaddict]

YOU ARE AWESOME! Thank you. I never would have found the extra spaces.

 

[Peter_SSs]

You are welcome. Glad we worked it out in the end.