hsandeep
Well-known Member
- Joined
- Dec 6, 2008
- Messages
- 1,226
- Office Version
- 2010
- Platform
- Windows
- 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
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