2variable vlookup? or extract last characters on string?
Posted by Mike on May 31, 2001 2:23 PM
Hello,
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?
Mike
Posted by Aladin Akyurek on May 31, 2001 2:37 PM
Mike
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:
=RIGHT(A1,B1)
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?
Aladin
