Forum Discussion
If 2 columns text matches, then result with 3rd columns data
Hello! I am using ODBC to pull data from our inventory system but it does not give me the full information I need. We have a 2 digit make code that I would like the full name spelled out in the nex...
I have received your workbook. The TB_KEY column on the PFWTAB sheet contains extra spaces after the two-letter code, and so does the TB_DATA column. The following formula works:
=TRIM(VLOOKUP(H3&"*", PFWTAB[[TB_KEY]:[TB_DATA]], 3, FALSE))
See the workbook in your private messages.