{"id":3978,"date":"2019-01-14T12:41:23","date_gmt":"2019-01-14T12:41:23","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=3978"},"modified":"2024-03-29T13:43:49","modified_gmt":"2024-03-29T13:43:49","slug":"index-match-or-vlookup-to-return-multiple-values","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/formulas\/index-match-or-vlookup-to-return-multiple-values\/","title":{"rendered":"INDEX-MATCH or VLOOKUP to Return Multiple Values in Excel"},"content":{"rendered":"\n
When you want to look up a value in a table based on another cell, you can use the VLOOKUP function. But there is a problem with this function. It returns only one result even if more meet the criteria.<\/p>\n\n\n\n
Take a look at the following example.<\/p>\n\n\n\n