Complicated Problem Please help Collecting Data from a sheet to another

[can]

Hi,

=IF(AND(RAW_inapp!A150=B1, RAW_inapp!D150=$A$6), RAW_inapp!C150, "Wrong")

I use this formula.

My problem is that i have to increment this by 4 so next formulas will be ;

=IF(AND(RAW_inapp!A154=B1, RAW_inapp!D154=$A$6), RAW_inapp!C154, "Wrong")
=IF(AND(RAW_inapp!A158=B1, RAW_inapp!D158=$A$6), RAW_inapp!C158, "Wrong")
=IF(AND(RAW_inapp!A162=B1, RAW_inapp!D162=$A$6), RAW_inapp!C162, "Wrong")

Is there a way to do this?

I attached the screenshots so basically, i need to chech the rawinapp sheet and if the date and the name match, i will write it to the data sheet on the correct date. The only way i found is to do it like this by incrementing by 4 the reference value since the data is autogenerated and updating every day, it will always be in the 4th place.

Please let me know if there is a better way too. Thank you.

 

[can]

Thank you both for your answers!!!!

 

[AlanY]

Thank you both for your answers!!!!

you're welcome