conditional displaying of data
 

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.

conditional displaying of data
 

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.