Good day all,
I use the index(match) formulas on a purchasing workbook. I enter in our internal part number. The formulas then retrieve all the other information...manufacturer, part number, price...from our database workbook.
Recently we lost the drive that had the database. I had to make a purchase. Thinking I would have to hand type everything in I was surprised when I types in the part number the cell filled in with the information.
How is it getting this information if it does not have access to the database? I am thinking it is an "internal cache" the file used. Can I retrieve,view all of it?
Thank you,
Ken
Bookmarks