Unable to Cell match with if(and with unique identifiers to pull needed information

[blind099]

In excel I have two sheets within a document. In sheet two I have a unique identifier in column A and I am trying to match it to the same unique identifier in column A of sheet one. From there I need to take information from column s in the row in which the match occurs on sheet one and place it in a different column in sheet two. I will only take that information if column z in sheet one and b sheet two match and if the month in sheet 1 matches to the month in sheet 2. I have tried a couple ways have been unsuccessful. I found that if I had the number of the row where the unique identifier matches then I am ok. The only way I have been able to get this to work is with the formula below if the * is known.

=IFERROR(IF(AND(($A10=Sheet1!$A*,Sheet2!$z18=$b*,MONTH(Sheet1!$c*)=c$7),Sheet1!$S*,0),"0")

Please help and if possible send the sample code needed to complete this task.

[arlu1201]

Hello blind099,

Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.