VLOOKUP on Alphanumeric

[fmaresca]

It appears that when doing a reconciliation of a listing of stocks and bonds, where the common identifier is a alphanumeric entry, it is not possible to use VLOOKUP (it seems to only work with numbers/values).

Any suggestions?

What I am attempting to do is take two worksheets in a workbook and match off the price per unit and quantity based off of a common identifer (the data in both sheets are in a different order). There are approximately 600 stocks and bonds to be matched in each sheet.

Any assistance would be greatly appreciated.

Thanks.

 

[Aladin Akyurek]

On 2002-11-04 16:52, fmaresca wrote:
Thank you, that is the problem. Which leads me to a related question to that problem. Without going into all 624 cells in Column A to manually fix them, how can I remove these extraneous spaces automatically?

Download free ASAP Utilities from

http://asap-utilities.com

which has the option you need for eliminating extraneous spaces.