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.
=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.