How to vlookup alphanumerical value as output

H

hsandeep

Well-known Member
Joined
Dec 6, 2008
Messages
1,213
Office Version
  1. 2010
Platform
  1. Windows
  2. Mobile
I am doing vlookup on another workbook.
Lookup_value is 'alphabetical'.
Table-array consists of the last column as alphabetical.
But I am getting #N/A!!!
Answer should be the last column in the table-array which is alphabetical.
How to accomplish?

Ex:
Peter PPP-1000

Answer PPP-1000
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

K
  • Question
Return a user specified number of cell values to a comma list randomly
Replies
1
Views
79
Eric W
Eric W
E
  • Solved
This one is tricky. VLookup but return a different cell value
Replies
6
Views
193
Alex Blakenburg
A
C
  • Solved
If VLOOKUP is @NA check Table 2
Replies
9
Views
455
Joe4
Joe4
O
  • Question
Vlookup() and Index(Match()) returning N/A, even though the lookup value exists in the range and is identical to that value within the range.
Replies
6
Views
1K
nemmi69
nemmi69
D
  • Solved
Vlookup/Index that returns all distinct values, but returns in a row?
Replies
8
Views
396
Fluff
Fluff

Forum statistics

Threads
1,215,065
Messages
6,122,944
Members
449,095
Latest member
nmaske

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