Related:

- Not sure which formula to use? please help
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Credit summation formula - Guide

## 1 response

The syntax is as follows:

VLOOKUP (lookup_value, table_array, col_index_num)

So if we wanted to check our cell against another table, we would put that table range in the "Table_Array" variable. the lookup value would be one of the three you were looking for. The third part is the most confusing, it will return the value on the table_array that corresponds with the INDEX of the listing that matches FOR THE COLUMN THAT YOU SET! see the attached: