dimanche 17 octobre 2021

Use of Excel formula 'IF" and "AND" with multiple sheet to combine the data

I have two excel datasheets i.e. 'Data' and 'Sheet1'. Now, I am using the following excel formula to bring some data from 'Sheet1' to 'Data':

=IF(AND(Data!B2=Sheet1!A2,Data!C2="Argentina"),Data!AU2:CR2=Sheet1!B2:AY2,NAN)

The formula return "#NAME?".

Can you help solve this issue? Thanks in advance.

Aucun commentaire:

Enregistrer un commentaire