Archive of Mr Excel Message Board

Back to Forms in Excel VBA archive index
Back to archive home

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

Check out our Excel Resources

Re: 2variable vlookup? or extract last characters on string?

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

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.