Arrays (Excel 2003)

Topic

New Reply

I can never get these to work . I had submitted a post previously for help with this same type of array. Can’t seem to get it to work on this spreadsheet. Help!

Summary worksheet, Cell F5. It should be looking at columns F and G of the Entry worksheet.

Please let me know what I am doing wrong this time

Reply | Quote

Replies

The named ranges on the Entry worksheet (Department, Error, Pieces and Trays) all start in row 5, below the actual data, so there is nothing that matches… If you redefine them to start in row 2, you should get better results.

Reply | Quote

The named ranges on the Entry worksheet (Department, Error, Pieces and Trays) all start in row 5, below the actual data, so there is nothing that matches… If you redefine them to start in row 2, you should get better results.

Reply | Quote