{"id":15208,"date":"2023-03-28T13:35:44","date_gmt":"2023-03-28T13:35:44","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=15208"},"modified":"2024-02-19T14:52:13","modified_gmt":"2024-02-19T14:52:13","slug":"use-vlookup-and-indirect-functions-together-in-excel","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/formulas\/use-vlookup-and-indirect-functions-together-in-excel\/","title":{"rendered":"Use VLOOKUP and INDIRECT Functions Together in Excel"},"content":{"rendered":"\n
You can use the VLOOKUP<\/strong> and INDIRECT<\/strong> functions together in Excel to look up a value in a table in a different worksheet or workbook.<\/p>\n\n\n\n The VLOOKUP function searches for a value in the leftmost column of a table and returns a value in the same row from a specified column. The INDIRECT function returns a reference to a cell, based on a text string.<\/p>\n\n\n\n Here’s an example of how you can use these functions together:<\/p>\n\n\n\n Assume you have three worksheets in your workbook: 2021<\/strong>, 2022<\/strong>, and Summary<\/strong>.<\/p>\n\n\n\n