Hello, I am running Excel 2003. Im trying to accomplish a lookup. On sheet 1, in column A, I have values such as: A, B, C, D. These values repeat themselves. A small example: a date place b date place b date place a date place c date place On my second sheet, we'll call it the "a" sheet, I want this sheet to basically list only the cells that had "a" in column A from sheet 1. So I would want to see on this sheet (using above example) a date place a date place I've tried using VLOOKUP, but am getting strange results. I think it's because the values repeat themelves ..but Im not sure. Any help is greatly appreciated.

I have a hunch that you will either need to use Array formulas or some ideas from here Good luck

i am having the same problem... VLOOKUP get only the first entry ...

I would suggest Sort by column A and then copy and paste to the "a" sheet. Using a macro you can do a multi-vlookup. It is cumbersome but a real time saver. Bryan