Vlookup
Basic Vlookup
Vlookup is a function used for matching in excel, it takes these arguments:
=VLOOKUP(What you want to look up,
where you want to look for it,
the column number in the range containing the value to return,
return an Approximate or Exact match – indicated as 1/TRUE, or 0/FALSE)
There are some limitations of using Vlookup. For one thing, it only returns the first match from a top-down search. Meaning if your table is sorted in a certain way, Vlookup will only return the first result it finds, even if there is another valid result below the first entry. For instance:
=VLOOKUP(What you want to look up,
where you want to look for it,
the column number in the range containing the value to return,
return an Approximate or Exact match – indicated as 1/TRUE, or 0/FALSE)
There are some limitations of using Vlookup. For one thing, it only returns the first match from a top-down search. Meaning if your table is sorted in a certain way, Vlookup will only return the first result it finds, even if there is another valid result below the first entry. For instance:
Vlookup returns the first match in the 3rd column, which is 1001.