Aug 19 2022 10:42 AM
Aug 20 2022 01:12 AM - edited Aug 20 2022 01:15 AM
Comfortable in vlookup and Index match please follow simple formula,
Aug 20 2022 01:30 PM
That only worked because you forgot to fix the part E2:E5. Otherwise, "Part X" also comes out in line 3, because x and y have the same entry in the final report.
That is the reason why I used filter().
Aug 24 2022 12:31 PM
Jul 28 2023 06:19 AM
Hi Expert guys,
I need same help with the below data.
1st table contains the below data.
2nd table(as below data) - 1st column contains the random array arrangement of the 1st table values of 1st column.
Expecting exact corresponding respective values of 2nd table - 1st column results in the 2nd table - 2nd column through =VLOOKUP formula or any other possibility in excel from the values of the 1st table - 2nd column.
1) 1st table.
2) 2nd table
Jul 28 2023 07:12 AM
That's exactly VLOOKUP as you say or any other lookup function available in your version of Excel.
In general, that's new question, better if you start it as new conversation from here https://techcommunity.microsoft.com/t5/excel/bd-p/ExcelGeneral