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.
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.