How to match a name to a value ?

[rasolrpd]

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

[AliGW]

Welcome to the forum! Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. In this case, mention that you are wanting to match a name to a value. Changing your thread title is not optional. Thanks!

No help to be offered, please, until the OP complies with this request.

When you have changed your thread title, then will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one.

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution is also shown (mock up the results manually).

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as they cause lots of problems.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.

[FDibbins]

Hi, welcome to the forum

rest of post deleted ( too slow lol)

[JohnTopley]

Please change your thread title to better describe your problem: "Find customer with maximum value" ???

Attach a sample workbook.

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[rasolrpd]

Here is the xlsx file.

[AliGW]

Thank you.

The name Ramtin does not exist in the lookup table. The person with that debt is Samir - is this the name you want to return? If so, use this:

=INDEX(C:C,MATCH(I12,D:D,0))

I do not fully understand the layout of your data - why is there a shorter set of data in columns A and B?

[JohnTopley]

To get name ..

=IFERROR(INDEX(Table2[ID],MATCH(MAX(D:D,E:E),Table2[Debt],0)),INDEX(Table2[ID],MATCH(MAX(D:D,E:E),Table2[Debt2],0)))

[rasolrpd]

Thank you.

The name Ramtin does not exist in the lookup table. The person with that debt is Samir - is this the name you want to return? If so, use this:

=INDEX(C:C,MATCH(I12,D:D,0))

I do not fully understand the layout of your data - why is there a shorter set of data in columns A and B?

Thank you very much,your solution solves my problem.
And yes that should be samir,I forgot to update the cell,and about your question,names in column A haven't yet got any Id.Also any ID can have a name which is not set yet.

[AliGW]

You're welcome!

Not sure what your last question is asking - sorry.