Vlookup data from sheets in Google sheets file

12 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]