Skip to main content

How to get Vlookup form one google sheet to another

 How to get Vlookup from one google sheet to another 

Hi, Friends through this article going to teach you how to get vlookup from one google sheet to another google sheet.

Let's get started, let's take one example google sheet with example data. Name is taking, "one google sheet". 

one google sheet


And take the second google sheet. Name taking, "Second google sheet".

second google sheet

Now show you how to get vlookup from one google sheet to another google sheet. let's put this formula to get the result details from one google sheet. after putting in this formula you will get result data. 

=IFERROR(VLOOKUP(A2,IMPORTRANGE("https://docs.google.com/spreadsheets/d/1O9q6nWmUm9Hc52xVo0Wz1q2IW03EkO-8pJmWqKpnPaU/edit#gid=0","maindata!A:C"),3,false),)


Get copy sheet address for Importance from "only google sheet" address bar.

=
IFERROR(VLOOKUP(A2,IMPORTRANGE("https://docs.google.com/spreadsheets/d/1O9q6nWmUm9Hc52xVo0Wz1q2IW03EkO-8pJmWqKpnPaU/edit#gid=0","maindata!A:C"),3,false),)


IF you want to get any help please comment below. 
Thanks for reading this blog and learn something new.






Comments