match the same name to get the equivalent number

[ledyvilatuba]

hello good day everyone! How can I match the same name to get the equivalent number or result to the corresponding name in one database or lists of nmes... thank you

[vlady]

Welcome to the forum Kabayan.
vlookup,index/match,sumproduct,lookup
There are numerous functions that can be used but can you post a workbook and sample expected output you want to achieve.

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. 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 demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Regards,
Vladimir