Results 1 to 9 of 9

How to match a name to a value ?

Threaded View

  1. #1
    Registered User
    Join Date
    04-13-2017
    Location
    Iran
    MS-Off Ver
    2013
    Posts
    5

    How to match a name to a value ?

    Hi guys
    I need a formula to perform a very specific action.As you can see in the image uploaded,I've written IDes in C column and amount of their debts in front of them which are in column D.In column I12 I have asked the program to select the highest amount of debt among all.Here is the problem,I can not ask Excel to write the owner of debt next to it (I12).But as you can see,I manually wrote.
    Thank you for taking time.
    and with thanking Forum Moderator here is the xlsx link added.


    Capture.PNG
    Attached Files Attached Files
    Last edited by rasolrpd; 04-13-2017 at 04:39 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 8
    Last Post: 06-02-2016, 03:00 AM
  2. [SOLVED] a function to copy the things needed from one sheet to another. only the ones needed
    By karim.zheng in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 10-31-2015, 09:49 AM
  3. Modifying "vloookup" function for a specific task. Help needed.
    By Dolke in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-13-2013, 11:22 AM
  4. Help needed for a specific IF function
    By willm in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-31-2011, 09:11 AM
  5. macro needed to sum specific data in specific cells
    By nasser in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-24-2011, 08:11 AM
  6. Formula needed that changes according to a specific day
    By mr63249 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-12-2008, 09:58 PM
  7. Help needed in finding specific series via row.
    By hadmybreaktoday in forum Excel Formulas & Functions
    Replies: 43
    Last Post: 09-06-2005, 07:05 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