I'm trying to modify an existing formula to return cell results but exclude the first character. The data entry person adds a # to the beginning of a part number and my formula brings back the results like it needs to however for coding I need to remove the # from the part number. It's one of those 'I know there's a way' but I can't think how to incorporate it. I'm thinking something with LEFT but I'm not fluent enough to figure out how or where.
This formula works, I just need to find a way to exclude the first character of the results. The part numbers (without the #) are no longer than three numbers and letters.
This is my formula: [ =IFERROR(VLOOKUP(D37,Table2[[#All],[LINE '#]:[QUANTITY]],2,FALSE),"") ]
Thank you for your help.
This formula works, I just need to find a way to exclude the first character of the results. The part numbers (without the #) are no longer than three numbers and letters.
This is my formula: [ =IFERROR(VLOOKUP(D37,Table2[[#All],[LINE '#]:[QUANTITY]],2,FALSE),"") ]
Thank you for your help.