+ Reply to Thread
Results 1 to 2 of 2

Return the value of cell based from 2 criteria

  1. #1
    Forum Contributor corinereyes's Avatar
    Join Date
    12-02-2003
    Location
    Philippines
    MS-Off Ver
    MS Excel 2016
    Posts
    520

    Return the value of cell based from 2 criteria

    Dear All,

    I hope everyone is having a good day.

    I had a previous question that was solved yesterday and now I'm having another issue because the table that the formula is referencing changed.

    https://www.excelforum.com/excel-for...ml#post5429958

    I have a sample excel file attached. In sheet named "salary" cell A2 contains an old salary and B2 contains the new salary. What it needs to find is the exact values of A2 and B2 in the other sheet named "Medical Scale" and returns the content of the Column heading (B1 to AC1) for Level and the content of the column heading (B2 to AC2) for the Grade, the value that should return is the highest value which is the new salary.

    I hope anyone can assist me. Thank you in advance.

    **I have reattached the correct file.

    Corine
    Attached Files Attached Files
    Last edited by corinereyes; 11-27-2020 at 04:41 PM.
    Corine

  2. #2
    Forum Contributor corinereyes's Avatar
    Join Date
    12-02-2003
    Location
    Philippines
    MS-Off Ver
    MS Excel 2016
    Posts
    520

    Re: Return the value of cell based from 2 criteria

    hello guys

    i got it working!

    c2 =
    Please Login or Register  to view this content.
    d2 =
    Please Login or Register  to view this content.
    CTRL+SHIFT+ENTER

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Return a date in a cell based on two criteria
    By timtim91 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-04-2020, 12:32 PM
  2. [SOLVED] return cell in row based on two criteria
    By mattzkn in forum Excel General
    Replies: 6
    Last Post: 03-01-2020, 10:51 AM
  3. IF formula return a value based on criteria in a cell
    By lucipurr in forum Excel General
    Replies: 2
    Last Post: 02-01-2019, 10:41 AM
  4. [SOLVED] how to return a value based on other cell criteria
    By deanblew in forum Excel General
    Replies: 5
    Last Post: 08-11-2017, 05:01 AM
  5. [SOLVED] Return the value of a cell based on 4 criteria
    By rossi_69 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-24-2015, 03:03 PM
  6. [SOLVED] Return cell value based on criteria of 2 columns
    By Fatnslow in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-03-2012, 04:52 AM
  7. return cell references based on criteria
    By blakeyoung in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-22-2008, 09:10 PM

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