I’m trying to modify the help I found at this web address to my needs.
http://www.j-walk.com/ss/excel/usertips/tip020.htm
I have too much information to put it in a pivot table or 2 variable table format. I’m actually trying to get it out of Access 97. If someone can help me with that, I’m open to it.
In lieu of that, I brought my Access information into my workbook on 2 spreadsheets. (There are 102870 records)
The information shows DirectoryCode in Column A, an ItemCode in Column B, and a Rate in Column C.
On another Worksheet, I need a formula in Column C that will display the appropriate rate for a Directory Code in Column A and an ItemCode in Column B.
What is the path of least resistance here?
Thanks all.
