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.

This can be done using VLOOKUP:
D1=VLOOKUP(C1,Sheet2!A1:B4, 2)
this formula looks for C1's value in Sheet2 Range A1:A4, and returns the
number from the 2nd column (B) in the same row that the data was found.
--
Charles Chickering

"A good example is twice the value of good advice."


"da'mick" wrote:

> 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.
>
>