google sheets vlookup - Free Excel Tutorial

Sort Dynamic Data in google sheets

 This article will talk about how to sort the dynamic data in google sheets automatically. How to use RANK formula to sort the data of a given dynamic range in google sheets. Sort Dynamic Data suppose you have a list of data in cell range A1:B5, and you want to sort the dynamic data in… read more »

Google Sheets Nexted IF Functions (Statements) Tutorial (15 IF Formulas examples)

This tutorial will guide you how to use nested Google Sheets IF function  (include multiple If statements in Google Sheets formula) with syntax and provide about 15 nested IF formula examples with the detailed explanation in Google Spreadsheets. Description The Google Sheets IF function perform a logical test to return one value if the condition… read more »

Google Sheets VLOOKUP Function

This post will guide you how to use Google Sheets VLOOKUP function with syntax and examples. Description The Google Sheets VLOOKUP function lookup a value in the first column of the table and return the value in the same row based on index_num position.. The VLOOKUP function can be used to search down the first… read more »