cross reference

Hi I have a data dump and want to show all data that meets x criteria. There is a drop down box a the top of the sheet where a date can be selected, once selected i want formulas underneath to pull back all entries relating to that criteria from the database extract which is in a separate...

If someone could please help: I have the following two sheets: <TBODY> Sheet 1</SPAN> Sheet 2</SPAN> Inventory Required</SPAN> Item1</SPAN> Item 2</SPAN> Item 3</SPAN> Inventory Required</SPAN> Item1</SPAN> Item 2</SPAN> Item 3</SPAN> Product</SPAN>...

Essentially, we have one master Excel sheet for forecasting. There are 6 account managers that fill in their incoming and projected work in their own spreadsheets, all in the same format/columns and information. We need the master spreadsheet to gather data from the other excel documents for...

I've been trying use excel to figure out amounts reserve Soldiers would be paid for working a certian number of days. I need to cross reference rank and time in service for each Soldier. I decided that it would be faster to use excel and use a cross reference formula to figure it out. I've tried...

Hi All, I have a problem with name matching. I have 2 databases that I have inherited both containing the same account names. I need to combine these names into one summary page/reference page. My problem arrises where the names have either been spelt wrong or are entered differently. I.e...

I really don't know if this is even possible in excel but will try to explain what I am trying to do and if it is possible this will save a lot of time!! I have a master workbook with client number as column heading and various other headings across the worksheet. Down the column for client...