Ladkisson
asked on
Cross reference through lookup formula
Hello!
Please refer to the attached file: Tab "A" has the needed data and Tab "B" should referenece data from Tab "A"
Cell C3 needs to map C2 &A3 through tab A and let me know if they are connected or not.
Tab A has 55 individual stores and each of these stores has 10 assigned stores to them. The yellow section in tab B is what needs to be populated through a formula.
thanks!
Cross-reference.xlsx
Please refer to the attached file: Tab "A" has the needed data and Tab "B" should referenece data from Tab "A"
Cell C3 needs to map C2 &A3 through tab A and let me know if they are connected or not.
Tab A has 55 individual stores and each of these stores has 10 assigned stores to them. The yellow section in tab B is what needs to be populated through a formula.
thanks!
Cross-reference.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Use this formula instead
=IF(ISERROR(ADDRESS(MATCH( 1,INDEX((A !$B$1:$B$1 000=$A3)*( A!$A$1:$A$ 1000=C$2), 0),0),2)), "Not Connected","Connected")
=IF(ISERROR(ADDRESS(MATCH(
OK, I thought you wanted the location as shown, if not then for just "connected" or "not connected" try this version
=IF(COUNTIFS(A!$B$1:$B$100 0,$A3,A!$A $1:$A$1000 ,C$2),"con nected","n ot connected")
regards, barry
=IF(COUNTIFS(A!$B$1:$B$100
regards, barry
ASKER
156 not connected
168 $B$9