Check the data from two sheet and result on third sheet

[shiven.k]

Hi Forum,

Need your help, I am stuck to one problem in Excel.

Problem:

I have excel file, consists of 4 sheets Data, PF, Gratuity, Discrepancy. Here I have Emp no. field as key field, now here first I have to check Data Sheet data with PF.

For example,

Suppose, we are considering Emp no.: 4 from data sheet. It will check in PF sheet for same Emp no. if it find then it will check the relationship and first name and last name from data sheet. If it is ok then it will return output in discrepancy sheet with OK. Discrepancy sheet format:

Emp No. Spouse Child1 Child2 Father
(All the relationship present in Data Sheet in Column)

4 OK
9 OK OK OK NA

And so on.

Please help,
Thanks,
Shivendra