You are here:

Excel/Response to your question

Advertisement


Question
Do the files in the "search" page exist in MORE THAN ONE of the 5 folders??
No. Each of the file folders (1-5) contains a continuation of the excel files in number sequences. All the Excel files could be put in a single folder with no duplication. But that would mean about 70,000 files all sitting in one location. I'm sure Excel could handle it, but it seemed safer to break them up among five folders.
Thank you for the question. I just had no way yesterday to respond to your question because it doesn't seen the service has such a reply to question function.
Let me know if I've overlooked anything else you might need to know.
   Barry

Answer
Barry

Sorry to be late in answering, but I am a CPA and I have been and still am just a bit busy right now.
I don't have the time to give you a complete answer but I would suggest you use the vlookup formula to do your search and bring back the data to your hits page.  What you would do is create a formula that would lookup in each of your files the file number you are looking for, but if no file is found, producing an error, then put nothing in as a result of the formula. the next part of the formula would be a vlookup in the second sheet then one in the third sheet etc until you have looked up in all of the sheets.  

With all of the files in one location you can write a lot simpler formula something like this

=VLOOKUP(search!A1,Sheet3!A1:B100000,2,FALSE)

Hope this gives you a bit of help.  If you have not solved it by the 4/16, shoot me an e-mail and I will see what I can come up with.

RIRSTRESS@AOL.COM

Richard
Florida
USA  
About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here

Excel

All Answers


Answers by Expert:


Ask Experts

Volunteer


Richard Roberts

Expertise

Can assist you in most areas of Excel, have been working with it for about 15 years in many types of applications, but primarily in financial and accounting applications. I am a CPA and many client or client problems have necessitated the use of excel. I am not an expert in charting, macros, or pivot tables.

Experience

Have been working with Excel for about 20 years primarily in accounting and financial areas.

Education/Credentials
BA, Certified Public Accountant

©2016 About.com. All rights reserved.