Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro for displaying conditional formatting | Excel Discussion (Misc queries) | |||
Help with displaying data | Excel Worksheet Functions | |||
Bar data not displaying | Charts and Charting in Excel | |||
Would like help with displaying data if are a certain value is pre | Excel Worksheet Functions | |||
Add data labels without displaying data points? | Charts and Charting in Excel |