conditional displaying of data

D

da'mick

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

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Too much data for this code? 4
The Information cannot be pasted Message 3
Split 9 weeks of data on a worksheet into 9 separate worksheets 1
Auto Duplicating Worksheets and Insterting Data from Different Worksheet 4
Altering Paste Data 2
range construction 4
Excel Vba - Comparing 2 ranges of data and displaying result in another worksheet 4
Modifying Ron De Bruin's "Create summary sheet from different workbooks" 7

Top