VLOOKUP( )
Vlookup() function on excel 2007/WPS Office is used to serach a particular value of a cell in particular cell range on the same worksheet or different worksheet. The formula is as follow
VLOOKUP(lookupvalue , range on the same sheet/different worksheet,index no of column from which we want the value,Exact Mach means "FALSE/0 to write" or Approximate means we have to write 1/TRUE)
sample table depicted below with EXAMPLE-1
Suppose we want to search for Departure time of Trian Name "KOL_JTN" in a list containing 1000 train list we can easily get the train time with in a second whose formula is as follow
Steps
Comments