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

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