Results 1 to 3 of 3

How do I find a value in a table based on other criteria

Threaded View

  1. #1
    Registered User
    Join Date
    05-30-2009
    Location
    Christchurch, New Zealand
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    3

    How do I find a value in a table based on other criteria

    I'm trying to find a suitable formula that looks at two cells (J3 and V3) in Sheet 1 (a person's employment grade (e.g. 18) and their performance percentage e.g. 92.5%), finds those values in a table on Sheet 2 and then places the corresponding value from that table in Sheet 1 at cell Z3.

    Any help would be greatly appreciated.
    Attached Files Attached Files
    Last edited by dinonz1965; 05-31-2009 at 02:53 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1