Vlookup
Vlookup fetch a cell value with reference to column no and lookup value .
Formula
=vlookup(Lookup value, array, colno)
Lookup value is value which we want excel to look in Table
array is ref of table in which excel will find
In this case i want rating of a company Aviva. so for lookup value i gave ref of cell which have cell value of avia then table array of whole table , then column no 3 because ratings are given in column no 3
Note always remember for Vlookup function to work lookup value should always be in first column otherwise this formula or function will not work .
Comments
Post a Comment