Please Login or Register  to view this content.
Here VLOOKUP takes input as Id[B'Emp_Tag'] and checks in 'Data' Sheet and if found returns 3rd column[Date] which is compared with Temp.
Here if this is true, the action to be done is to fetch corresponding 6th column.[ I mean the row in which Id matched and Temp equals fetched value, its corresponding 6th column] What needs to be done here ??

Hope I am clear.

Thanks,