Notifications
Clear all
General Excel Questions & Answers
3
Posts
2
Users
0
Reactions
756
Views
Topic starter
hello,
i want to search bring the ID and value of the above date to the lower data.... how can I slove it??
the file is also attached below for the reference
| PreFix & SufFix Differnce | ||||
| Name | ID | Value | ||
| Dr. Sanjeev | 1000-165-B100 | 100 | ||
| Miss Payal Rani | 1001-540-C101 | 200 | ||
| XYZ & Company | 1002-394-M102 | 300 | ||
| Master Shubham | 1003-307-Q103 | 400 | ||
| ABC Corp Pvt Ltd. | 1004-848-S104 | 500 | ||
| M/s ChampExcel Consulting | 1005-155-S105 | 600 | ||
| Name | ID | Value | ||
| Sanjeev | ||||
| Payal | ||||
| XYZ & Co | ||||
| ABC Corp | ||||
| ChampExcel |
Posted : 16/01/2021 3:02 am
Hi kunal upreti,
You can perform this operation with MATCH - INDEX and a joker.
BR,
Lionel
Posted : 16/01/2021 8:02 am
Topic starter
Thanks Lionel 🙂
Posted : 17/01/2021 12:43 am