Hello,
I am using the following formula:
INDEX('LP AX Flat File'!$A$7:$AZ$25, MATCH($A7, 'LP AX Flat File'!$A$7:$A$25, 0), MATCH(AJ$6, 'LP AX Flat File'!$A$6:$AZ$6,0))
I would like to tweak it so that it matches the left 10 characters of AJ$6 to that word in any position in 'LP AX Flat File'!$A$6:$AZ$6.
(Essentially "*"&'LP AX Flat File'!$A$6:$AZ$6&"*"...but that method doesn't work.)
Any suggestions?
Thanks for your help!
I am using the following formula:
INDEX('LP AX Flat File'!$A$7:$AZ$25, MATCH($A7, 'LP AX Flat File'!$A$7:$A$25, 0), MATCH(AJ$6, 'LP AX Flat File'!$A$6:$AZ$6,0))
I would like to tweak it so that it matches the left 10 characters of AJ$6 to that word in any position in 'LP AX Flat File'!$A$6:$AZ$6.
(Essentially "*"&'LP AX Flat File'!$A$6:$AZ$6&"*"...but that method doesn't work.)
Any suggestions?
Thanks for your help!