MrExcel Publishing
Your One Stop for Excel Tips & Solutions

2variable vlookup? or extract last characters on string?

Posted by Mike on May 31, 2001 2:23 PM

I'm working with Excel 2000 and I would like to know
if there are 2 variable VLOOKUP functions or is it
possible to copy the last say 10 characters of a
string to another cell.
It would also be really nice if it were possible to
use different strings which could be turned into
commands (ie. form a string that could be the
parameters for the VLOOKUP function). Or is there a
way of doing that?


Posted by Aladin Akyurek on May 31, 2001 2:37 PM


Is it possible that you post a snippet of your data and tell us what you want to look up?

"Copying" 10 last chars or so of a string can be done with the RIGHT function:

You can put the following in say C1:


where A1 contains the original string and B1 the number of last chars you want to have in C1.

The last part of your post sounds intriguing: What do you exactly in mind?