Vlookup only the last 6 characters
Fantastic - thank you so much.
"bapeltzer" wrote:
The RIGHT function is returning a text value, and I'm guessing that the
values in column J are true numbers. So you'd need to covert the text back
to numbers in order to have the lookup work properly:
=VLOOKUP(VALUE(RIGHT(A4,6)),$J$4:$K$7,2,0)
"JoeP" wrote:
I have a spreadsheet starting in cell A4. I want to lookup only the last 6
digits in column A and then lookup the value in column J and return the
appropriate value from column K.
The values in column A are 000322341; 000333456; etc.
The values in column J are 322341; 333456; etc.
Here is my current non working formula...
=VLOOKUP(RIGHT(A4,6),$J$4:$K$7,2,0)
Any help would be appreciated. Thanks.
|