Sep 22 2021 05:57 AM - edited Sep 22 2021 06:09 AM
Hi,
Can someone please help. How do i create a formula that reads what is in 5 or more columns but data in the same row, that reads from a list in another sheet to tell me if those words/values are present.
Thanking everyone in advance for the help.
Sep 22 2021 06:05 AM
Solution
You can try it using MATCH() formula
But I would suggest you, provide some sample data. Its not necessary be the original data, just some sample explaining your needs.
=MATCH(WhatYouAreLookingFor;WhereTheDataAre;0)
Sep 22 2021 06:21 AM
Sep 22 2021 06:26 AM
Sep 22 2021 06:31 AM
Sep 22 2021 06:05 AM
Solution
You can try it using MATCH() formula
But I would suggest you, provide some sample data. Its not necessary be the original data, just some sample explaining your needs.
=MATCH(WhatYouAreLookingFor;WhereTheDataAre;0)