I am having a problem trying to find and use the correct formula to do the following.
I have a sheet where some of the data can be repeated in multiple rows.
I want to search all rows to find if a row contains the value of two seperate columns:-
Master data is
Fld 1 Fld 2 Fld 3 Fld 4 Fld 5 Fld 6
Secondary Data
Fld1 Fld 2 Fld3 Fld4
What I want to do is to search and check whether each of entries in Field 1 above contains at least one instance of Atonic in Fld 6 of the Master data. I want to put Yes or Know in Fld 4 above.
I understand that this would possibly involve Lookup, Index, If and/or Match functions but I cannot work out how to do this.
The logic is to select Fld1 in each row in the Secondary Data and see if the Matching Fid 1 in the Master Data contains the Value Atonic in Fld 6. If True, I want to place Yes in Fld 4 of the Secondary Data
I hope this makes sense?
Could anybody help
I have a sheet where some of the data can be repeated in multiple rows.
I want to search all rows to find if a row contains the value of two seperate columns:-
Master data is
Fld 1 Fld 2 Fld 3 Fld 4 Fld 5 Fld 6
Secondary Data
Fld1 Fld 2 Fld3 Fld4
What I want to do is to search and check whether each of entries in Field 1 above contains at least one instance of Atonic in Fld 6 of the Master data. I want to put Yes or Know in Fld 4 above.
I understand that this would possibly involve Lookup, Index, If and/or Match functions but I cannot work out how to do this.
The logic is to select Fld1 in each row in the Secondary Data and see if the Matching Fid 1 in the Master Data contains the Value Atonic in Fld 6. If True, I want to place Yes in Fld 4 of the Secondary Data
I hope this makes sense?
Could anybody help