Vlookup is a most useful function of Google sheet that helps to search and element in a range of column. You can also use vlookup in Microsoft Excel. but the way of using vlookup by reference in Google sheet and Microsoft Excel might be different. if you are searching an element within the Sheet vlookup function this is something easier. and the Sintex is following.
In sheet 2 a1 vlookup is applied and reference of s of sheet1 is given.In this dialogue evaluation “ram” searched in sheet1 from sheet 2 and index is given as 1. output is “ram”.
you can also do this how to apply vlookup Google sheet.
But if you are giving reference to another sheet in vlookup function. the sintex will be following.=vlookup(“ram”,d1:e10,1,false)
=VLOOKUP("ram",Sheet1!D1:E10,1,)You can check out this sheet for vlookup with reference.
In sheet 2 a1 vlookup is applied and reference of s of sheet1 is given.In this dialogue evaluation “ram” searched in sheet1 from sheet 2 and index is given as 1. output is “ram”.
you can also do this how to apply vlookup Google sheet.
No comments:
Post a Comment