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 Original Name g7pD Test1 Part Name1 g7pD Test1 Part Name2 h8oR Test44 Part Name4 h8oR Test44 Part Name2 t4eY Test5 Part Name3
I already know that I need to use this formula to get the case sensitive match for the acct id
Account ID Account Name Part Name2 Exists? g7p8 Test1 3 ??formula here?? t4eY Test5 41 ??formula here??
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
”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.