Results 1 to 5 of 5

Vlookup range of cells to bring specific value

Threaded View

Flame Arrow Vlookup range of cells to... 10-10-2015, 07:23 AM
Richard Buttrey Re: I'm lost, multiple logics... 10-10-2015, 07:28 AM
Pepe Le Mokko Re: Vlookup range of cells to... 10-10-2015, 08:28 AM
Flame Arrow Re: Vlookup range of cells to... 10-10-2015, 08:47 AM
samba_ravi Re: Vlookup range of cells to... 10-10-2015, 10:17 AM
  1. #1
    Registered User
    Join Date
    07-06-2015
    Location
    Saudi Arabia
    MS-Off Ver
    2010
    Posts
    2

    Vlookup range of cells to bring specific value

    hi all,

    I'll try to simplify my request, so i have this sheet which contain specific grades for each nationality and in each cell there is a range of numbers which should return a specific value for me

    so if i have an employee grade A, his nationality B, (i want to compare his salary to the a range so if he is in range AB it show me Good, if he is in range AC it show me poor)

    so grade A Nationality B his salary 10,000, the range i have is min 7000 max 9000(poor) min 9100 max 11000(good), min 11500 max 15000(excellent)

    it is a logic formula with vlookup i think, can you help me guys?
    Attached Files Attached Files
    Last edited by Flame Arrow; 10-10-2015 at 08:46 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 10-01-2015, 03:02 PM
  2. [SOLVED] Multiple logics in one formula
    By bremen22 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-23-2013, 06:17 PM
  3. Need help for multiple logicals/ nested logics if function
    By tussitje in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-06-2012, 06:24 AM
  4. Pls help with some AND IF logics.
    By taranjit in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 09-17-2012, 03:00 AM
  5. [SOLVED] Formula Help with three logics
    By ssanjju in forum Excel General
    Replies: 3
    Last Post: 08-09-2012, 10:15 PM
  6. Replies: 7
    Last Post: 06-05-2012, 07:18 PM
  7. filters logics
    By abarwinski in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-16-2005, 06:53 AM

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