need a formula that will pull an exact match from multiple columns
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
but I also need to match across that row the specific 'Part Name2' ($c$1) - part name is not case sensitive