Get Data From Another Sheet in Excel: 3 Ways to do it

This can be done with a single function

3 min. read

Updated onOctober 7, 2024

updated onOctober 7, 2024

Share this article

Improve this guide

Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more

Often when working with Excel you need to get data from another sheet to show it. If you don’t know how to do that, this guide is here to help you.

How do I pull data from another sheet in Excel?

1. Use the formula

There are other methods to this, and we covered them in our guide on how toreference another sheet in Excel, so don’t miss it.

2. Use VLOOKUP

For more information, let’s quickly explain what this function does:

This is perfect if you need to get Excel data from another sheet based on cell value.

3. Use XLOOKUP

Similarly to the previous function, we’re looking for value from cell A2 in the WindowsReport sheet and are scanning the A column in that sheet for matches.

If there’s a match, we’ll return the corresponding value from the column B or Not Found if there’s no match. This is a perfect method to pull data from another sheet based on criteria in Excel, so don’t hesitate to try it.

To learn the difference between the two, we have a great guide onXLOOKUP vs VLOOKUPso you might want to check it out.

Can you automatically pull data from one Excel sheet to another?

Yes, after you configure a formula to get data from another sheet in Excel, and once you do that, you canapply the formula to an entire Excel columnto fill the data automatically.

This comes in handy especially when the Power Query add-in throws theexcel error initialization of the data source failed.

If you want to learn more about Excel, don’t miss our guide on how toswitch columns and rows in Excel.

This is everything you need to know to get data from another Excel sheet from the same workbook. If you have any other suggestions, share them in the comments section below.

Get Data From Another Sheet in Excel: 3 Ways to do it#

How do I pull data from another sheet in Excel?#

1. Use the formula#

2. Use VLOOKUP#

3. Use XLOOKUP#

Can you automatically pull data from one Excel sheet to another?#