Using a sheet to organize data to fit an exact order and fill in null values when data is unavailable. Data is being pasted from an exported sheet in another program.
destination formula returns #NAME? as =IF(ISNA,0,(VLOOKUP(A8,H3:O21,2,FALSE))) and obviously a 0 value for =IF(ISERROR(VLOOKUP(A9,$H$3:$U$68,2,FALSE)),0)
Formulas in Column D support the lookup column A
Column A is a three digit billing code stored as text (ex. 001)
Column C is a description
Column D is the monetary value
Past from an external sheet in cell H3 extending over 1 column and down as many as needed is the table_array.
my problem. the values in Column H are a combination of Code and description. The descriptions may not be an exact match to Column C but the three digit codes are a match.
how do I rework my vlookup to search only the first 3 characters of column H?