Related:
- Not sure which formula to use? please help
- Number to words in excel formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel grade formula - Guide
- Credit summation formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
1 response
This could be solved with a VLOOKUP formula.
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:

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:
