V Lookup

V

VbaHell

Well-known Member
Joined
Jan 30, 2011
Messages
1,220
Hello one and all

I am using Excel 2007

Is it possible to complete a Vlookup against a cell and only check the last for charactors in that cell

In other words Vlookup 4567 to 4567

TRY10234567 10234567
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
Sort by date Sort by votes
If it's just the lookup_value where this check needs to be carried out, try:

Code: 
=VLOOKUP(RIGHT(A2,4),C$2:D$11,2,0)
Committed with just ENTER.

If it's both the lookup_value and table_array where this check needs to be carried out, try:

Code: 
=VLOOKUP(RIGHT(A2,4),RIGHT(C$2:D$11,4),2,0)
Which needs committing with CTRL+SHIFT+ENTER.

Does this help?

Matty
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Solved
VLOOKUP with IF or LOOKUP - Which is the right one to use?
Replies
5
Views
458
6StringJazzer
6StringJazzer
N
  • Solved
V-Lookup Issues
Replies
4
Views
223
dreid1011
dreid1011
M
  • Solved
VLookup Half Works
Replies
5
Views
492
Fluff
Fluff
E
  • Question Question
Lookup 2/1 works on one line and not on others
Replies
5
Views
159
Fluff
Fluff
C
  • Solved
Use a Vlookup only when a separate column contains a certain text.
Replies
7
Views
456
chewybar1986
C

Forum statistics

Threads
1,224,568
Messages
6,179,595
Members
452,927
Latest member
whitfieldcraig

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top