Forum Discussion
Solved
Look up multiple matching values
I am trying to find a formula for highlighted cells H2 and H3. My desired result is on "Final Result" table. Table 1 and Table 2 are on separate sheets. Thanks.
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
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
