VLOOKUP: Looks up for the value in column mentioned in par3 from a row that macthes with value in par1 and datasource range mentioned.
VLOOKUP(parl,par2,par3,par4)
Has 4 parameters:
par1 - Your input data(cell or column name).
par2 - Your souce data(exclude columns). It could be from other sheets too
par3 - Column name from where you wanted to pull the data
par4 - true or false(exact match)
Is it mandatory to have par1 related data in 1st column in par2(data range) or it can be any column?
ReplyDeleteYes it is, Vlookup will just go to the left most column. So left most column is the reference for Vlookup.
DeleteIndex Match could replace Vlookup?
ReplyDeleteYes Index and Match combinely when written could replace Vlookup. I heard Index-Match is much faster than Vlook up as Vlookup do check for too many combinations.
DeleteHere is how Index-Match works.
=Index(columnoftargetdata,Match(lookupvalue,columnoflookupdata,0))
Here how it works is Match will return the index number(row) of the look up value and then Index will print the value in that row from the mentioned target column.
Here columnoftargetdata/lookupdata is Range of cells in the targetvaluecolumn/lookupdatacolumn.
Delete