Forum Discussion
rossshah
Aug 19, 2022Copper Contributor
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.
- Aug 19, 2022
SergeiBaklan
Jul 28, 2023Diamond Contributor
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
nagavardhan1122
Aug 14, 2023Copper Contributor