I have a cell that I must remove the first 2 characters "RO" for each value in a column on a sheet called
RAW DATA and put into a cell on a sheet called
ROSS DATA. Some of the values in that cell have 3 digits after the "RO", and some have 5 digits. To do that I used
Then I need to use this new resultant string as the lookup value in a VLOOKUP. The VLOOKUP will be looking at a named range called
DAP on a sheet called
DAP, in column 5 for an exact match, and I need it to return that value to the cell.
I have tried using
INDIRECT in different ways to no avail, and I'm not sure that I fully understand its usage. So at this point I am Googling for a method to do this and at a standstill.