Vlookup vs Index/Match

Vlookup

1. is easier,
2. Only search from left to right
3. May select multiple columns.
4. Vlookup Pattern
   1. =vlookup(Lookup Value, Rows to Search, Column # you want to return, False)

Index/Match

1.  Allows you to search in both directions (left to right, right to left.)
2. Select only the columns you want.
3. Adding additional columns to your data does not screw everything up.
4. Index/Match is easier to copy to the next column.
5. Index/Match Pattern
   1. =Index(Column with the answer,Match(Lookup Value, Column with the lookup Value, 0)