Vlookup
Vllookup looks for a value in the left most column of a table, then returns a value in the same row in the column you specify.
Vlookup can be applied to a table of any size. The cells within the table can be edited, changing the results of the information the function gives you.
- Vlookup needs a table to operate, infomation set out in rows and columns.
- Vlookup formula needs three pieces of information to operate:
- What cell it needs to look at for information (Where)
- What columns are included in the range (What)
- What column does the answer come from. (Answer Column)