Vlookup data from sheets in Google sheets file

49 Likes Comment
Google Sheet Vlookup

Working with data on Google Sheets.
You’ll know how powerful google sheet is

I could use the following functions :
1 . IMPORTRANGE (spreadsheet key, range_string) and
2 . IFERROR(A1,”Error in cell A1″)
Here is some example for you:
=IFERROR(vlookup(A2,IMPORTRANGE("https://docs.google.com/spreadsheets/d/google-sheed-docid/edit#gid=543140280","my data!A2:B12"),2,false),)

You might like

About the Author: Toc Xoan

This guy likes taking photos, hunting cheap tours, exploring the unique culture of every cities of Vietnam. Contact: [email protected]. I've created a dogecoin wallet to receive blog funding: DE6F5FisSCy7yz5rpHY1ChMSGYnDMpFZ1Q

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.