If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Vlookup only the last 6 characters
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. |
#2
|
|||
|
|||
Vlookup only the last 6 characters
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. |
#3
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|