Comments on: Can Google Sheets VLOOKUP From Another Sheet? (Easy 2024 Guide) https://spreadsheetpoint.com/formulas/how-to-vlookup-from-another-sheet-google-sheets/ Google Sheets Tips & Tutorials Thu, 07 Mar 2024 14:05:02 +0000 hourly 1 https://wordpress.org/?v=6.7.1 By: jm https://spreadsheetpoint.com/formulas/how-to-vlookup-from-another-sheet-google-sheets/#comment-13613 Thu, 15 Feb 2024 18:12:24 +0000 https://spreadsheetpoint.com/?p=2329#comment-13613 In reply to Ashish Mundra.

Hey Ashish, you should be able to use the VLOOKUP formula in the article to search for the same date in the other sheet. If you need to pull from another workbook, you can use IMPORTRANGE too.

]]> By: jmarkus https://spreadsheetpoint.com/formulas/how-to-vlookup-from-another-sheet-google-sheets/#comment-13486 Fri, 02 Feb 2024 13:01:56 +0000 https://spreadsheetpoint.com/?p=2329#comment-13486 In reply to Amy.

The easiest way would be a consolodated data source: a central database or master sheet. Otherwise using a database tool that supports cross-document searches. There’s no built-in feature to search multiple workbooks in Google Sheets.

]]> By: jmarkus https://spreadsheetpoint.com/formulas/how-to-vlookup-from-another-sheet-google-sheets/#comment-13485 Fri, 02 Feb 2024 13:00:02 +0000 https://spreadsheetpoint.com/?p=2329#comment-13485 In reply to hellokitty.

Thanks for pointing that out! We’ve updated the article to use a better formula.

]]> By: jmarkus https://spreadsheetpoint.com/formulas/how-to-vlookup-from-another-sheet-google-sheets/#comment-13484 Fri, 02 Feb 2024 12:59:13 +0000 https://spreadsheetpoint.com/?p=2329#comment-13484 In reply to Aleks.

You might have the wrong range selected in that “Sheet1!A2:B585” section

]]> By: Ashish Mundra https://spreadsheetpoint.com/formulas/how-to-vlookup-from-another-sheet-google-sheets/#comment-11978 Wed, 16 Aug 2023 14:59:41 +0000 https://spreadsheetpoint.com/?p=2329#comment-11978 Hi i want to know hwo to do vlookup from a pertical date to find the date in other sheet with same date to take data

]]> By: RK https://spreadsheetpoint.com/formulas/how-to-vlookup-from-another-sheet-google-sheets/#comment-11237 Wed, 12 Apr 2023 07:21:43 +0000 https://spreadsheetpoint.com/?p=2329#comment-11237 It’s not possible with huge data sets, like with rows that are 20’000+ and 50+ columns.

]]> By: Aleks https://spreadsheetpoint.com/formulas/how-to-vlookup-from-another-sheet-google-sheets/#comment-10733 Sat, 17 Dec 2022 16:11:22 +0000 https://spreadsheetpoint.com/?p=2329#comment-10733 =VLOOKUP(A1,IMPORTRANGE(“https://docs.google.com/spreadsheets/d/1EAvqzy9sVIgIRoEn7aCTQ8-2mLdNFk0l7kk5QAlx9EA/edit#gid=0″,”Sheet1!A2:B585”),2)

Could anybody tell why it give me wrong data in my case&

]]> By: Christopher Daniel https://spreadsheetpoint.com/formulas/how-to-vlookup-from-another-sheet-google-sheets/#comment-10712 Wed, 14 Dec 2022 03:18:40 +0000 https://spreadsheetpoint.com/?p=2329#comment-10712 In reply to Stephen.

Not in one formula but you could import the two ranges into new sheets and then do a new VLOOKUP on the new ones.

]]> By: Genadi https://spreadsheetpoint.com/formulas/how-to-vlookup-from-another-sheet-google-sheets/#comment-10196 Tue, 06 Sep 2022 12:16:29 +0000 https://spreadsheetpoint.com/?p=2329#comment-10196 I used the exact formula and didn’t get the result. Turns out the problem was that commans had to be semicolons

=VLOOKUP(A3;IMPORTRANGE(“https://…./edit#gid=0″;”WB!$B$2:$C$131”);2;false)

is the format that worked for me.

]]> By: Solomon https://spreadsheetpoint.com/formulas/how-to-vlookup-from-another-sheet-google-sheets/#comment-9643 Sun, 29 May 2022 15:04:49 +0000 https://spreadsheetpoint.com/?p=2329#comment-9643 This tutorial on VLOOKUP() is very impressive, useful and easy to understand. A very special thanks goes to the Author(s). Regards

]]>