troubleshooting Question

exact match over multiple columns

Avatar of sullisnyc44
sullisnyc44Flag for United States of America asked on
Microsoft OfficeMicrosoft ExcelMicrosoft Applications
10 Comments3 Solutions366 ViewsLast Modified:
need a formula that will pull an exact match from multiple columns

Lookup Table
Account ID	Account Name	Original Name
g7pD    	Test1   	Part Name1
g7pD    	Test1   	Part Name2
h8oR    	Test44   	Part Name4
h8oR    	Test44   	Part Name2
t4eY    	Test5   	Part Name3
I need to lookup the case sensitive account ID and the specific part name column header $c$1 in this case across the row of the lookup table
Account ID	Account Name	Part Name2	Exists?
g7p8    	Test1   	3       	??formula here??
t4eY    	Test5   	41      	??formula here??
I already know that I need to use this formula to get the case sensitive match for the acct id
1+MATCH(TRUE,EXACT(OldAcctIDs,A2),0)

but I also need to match across that row the specific 'Part Name2' ($c$1) - part name is not case sensitive
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 3 Answers and 10 Comments.
Start Free Trial
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 3 Answers and 10 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