Hello - I have the formula below but want to add ability to catch if B7 is not an exact match due to letters being lower or capital. i.e. ABcDE would not match ABCDE.
I tried to add TRUE and EXACT terminology into the formula but could not make it work or I had it wrong somehow... ugh.
Any help would be greatly appreciated!
=IFERROR(VLOOKUP(B7,'Pricing Table'!$AY$5:$BM$36,MATCH(B87,'Pricing Table'!$AY$4:$BM$4,0),FALSE),"N-Term/Mgs Combo Not Found On N-Term Data Table")
I tried to add TRUE and EXACT terminology into the formula but could not make it work or I had it wrong somehow... ugh.
Any help would be greatly appreciated!
=IFERROR(VLOOKUP(B7,'Pricing Table'!$AY$5:$BM$36,MATCH(B87,'Pricing Table'!$AY$4:$BM$4,0),FALSE),"N-Term/Mgs Combo Not Found On N-Term Data Table")