troubleshooting Question

Amend Formula

Avatar of Seamus2626
Seamus2626Flag for Ireland asked on
Microsoft Excel
3 Comments2 Solutions336 ViewsLast Modified:
Hi,

I have some formula that checks a cell, looks through a range and then returns the cell reference of any matching values.

I want a slight extension on this, so that it returns the cell reference of a value if it is the opposite direction as well

So if it was looking at 725 and in the range there was a calue -725, currently it would not return it is looking for 725, can i get the formula to look for 725 and -725?

Thanks
Seamus

=IF(ISNA(MATCH(F2,F3:F1000,0)),"",MATCH(F2,F3:F1000,0)+ROW()&IF(INDIRECT(ADDRESS(MATCH(F2,F3:F1000,0)+ROW(),10))="","",","&INDIRECT(ADDRESS(MATCH(F2,F3:F1000,0)+ROW(),10))))
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 2 Answers and 3 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros