Sure. In one workbook I have the look-up array which has billing codes in one column and billing descriptions in another column. The codes are numbered 1, 2, 3, ... 29 and the descriptions are 4-4-5 biweekly deduction, semi-annual 12 deductions, semi-annual 24 deductions, quarterly 12 deductions, biweekly billing and deduction,...
These are just a few examples. I have named the entire array BILLDED and I have named the description column BillDescriptions.
In another worksheet I have a cell (say A2) with a data validation list of BillDescriptions. In another cell I have a look-up function: =VLOOKUP(A2, BILLDED, 1, FALSE). Here the products codes are in the first column of the table.
I am recieving a N/A error and I think it is because of the mixed string of data. I'm using Excel 97.
I tried this problem out at home on a newer version of Excel and was able to solve to problem by moving the BillDescription column ahead of the code column but I'm not sure if this will work in 97.