In worksheet 1, column c, is listed various pay grades ranging from A -
I ( that's an i ), A1, M1 - M3 & X1 - X4.

On worksheet 2, column a is the same list, with the frequently updated
minimum, midpoint & maximum hourly and annual pay range data occupying
columns B - G.

What I am requesting assistance with is first determining if anyone
knows of a way to compare the pay grade in worksheet 1, column c
against worksheet 2, column a and then take the corresponding pay range
information from worksheet 2 and display it on worksheet 1?

Much thanks for any assistance and insight.