This is a piece of the table I am looking up in:
CODE Description
2A Pocket 2Panel/1Track-2P1
2B Pocket 2Panel/2Track-2P2
2b ByPass 2Panel/2Track-2BY2
3b ByPass 3Panel/2Track-3CO2
3c ByPass 3Panel/3Track-3BY3
3C Pocket 3Panel/3Track-3P3
VLOOKUP doesn't work, because it is not case-sensitive. Is there another way to do this? Even VBA?
M
CODE Description
2A Pocket 2Panel/1Track-2P1
2B Pocket 2Panel/2Track-2P2
2b ByPass 2Panel/2Track-2BY2
3b ByPass 3Panel/2Track-3CO2
3c ByPass 3Panel/3Track-3BY3
3C Pocket 3Panel/3Track-3P3
VLOOKUP doesn't work, because it is not case-sensitive. Is there another way to do this? Even VBA?
M