we are checking the email id of Employee against Employee ID.
Employee id 695 is checked for Email id and result is firstname.lastname@example.org
How to do
Where A12 is the look up value whose corresponding value need to be looked up
A2:D10 is range of table array where value has to be looked upon
3 is the Column no. from column A in which value has to be looked against A12
0 is the Range look up, put 0 to get the exact match.
Ensure the Cell value of Lookup_value cell and output cell are exactly same.
Common errors: Space in the start or end of the lookup_value or data retrieval cell
Lookup_value cell is in number format whereas data retrieval cell is in text format
Ensure Lookup_value column is before the Column_index_num
If you are planning to drag the formula ensure to put $ before and after the column alphabet, this will ensure no change in the values of tables arrays because of the dragging.