Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / December 2007

Tip: Looking for answers? Try searching our database.

Create a Formula

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
James D. Sheehan - 10 Dec 2007 20:59 GMT
I have a salary amount that I must examine against a salary matrix.  The
salary matrix has a lane and step number that allows me to use the index
function.  I must examine the matrix and return the lane number needed for
the salary amount to be equal or greater than the given salary.  I.E.  what
lane would a person have to be placed on to achieve a salary no less than
their current salary.  Any help appreciated.
Signature

James D. Sheehan

Bernard Liengme - 10 Dec 2007 21:40 GMT
Tell us how the 'lane' and salary data is arranged?
How is it sorted - salary ascending or descending?
If the lane is after (to the right or below) then we can use VLOOKUP (or
HLOOKUP), otherwise we need to play with INDEX and MATCH
best wishes
Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

>I have a salary amount that I must examine against a salary matrix.  The
> salary matrix has a lane and step number that allows me to use the index
[quoted text clipped - 3 lines]
> lane would a person have to be placed on to achieve a salary no less than
> their current salary.  Any help appreciated.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.