Hi!
I’m a newbie, no experience with excel or any other office tools. Sorry if I labeled the question in a wrong way
I need a function to find matches between two rows.
Lets say I have populated a column with each row containing numbers:
A1: 9 20 53 60 90 40
A2: 5 20 30 45 60 80
AN: …
So for example - in B1 i write: 60 5 30 80
The function should return a match in A2
Thanks!