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".
And take the second google sheet. Name taking, "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.
Comments
Post a Comment