{"id":3171,"date":"2019-09-20T11:30:04","date_gmt":"2019-09-20T09:30:04","guid":{"rendered":"https:\/\/www.ybierling.com\/v2\/?p=3171"},"modified":"2019-09-18T19:30:58","modified_gmt":"2019-09-18T17:30:58","slug":"how-to-make-a-vlookup-in-google-sheets","status":"publish","type":"post","link":"https:\/\/www.ybierling.com\/v2\/en\/how-to-make-a-vlookup-in-google-sheets\/","title":{"rendered":"How to make a Vlookup in Google Sheets?"},"content":{"rendered":"
\n

What is a Vlookup Google Sheets<\/h2>\n

Performing a Google Sheet Vlookup <\/a> is very similar to how to do vlookup in excel <\/a>, by using a single function to search for a string in a list of values, and returning a specific column on the same line as the value found.<\/p>\n

<\/span><\/span>The function Vlookup, which means vertical lookup, will scan a vertical list of data, and, when it finds a match with a given value, will return the value stored in the requested cell of the corresponding line matching the Google Sheet Vlookup <\/a> value.<\/span><\/p>\n

First of all, to do a Vlookup Google Sheets <\/a>, you have to start with an existing Google Sheet containing a list of data.<\/p>\n

Google Sheets <\/a>
\n<\/span><\/p>\n