returning multiple match values w/ Vlookup??

[bw26934]

Ok. The file I am working with is attached.

I am trying to come up with a way to lookup a value from column B and return all the values out of column E. For example, if I enter 1M I would return all the differing actuals out of column E that have 1M in column B.

I have racked my brain and can't figure this out.

Thanks so much for your help in advance!

-Ben

[NBVC]

See attached:

First get Count of matching records:

Please Login or Register  to view this content.

Then list matching records:

Please Login or Register  to view this content.

This formula is confirmed with CTRL+SHIFT+ENTER not just ENTER...

Then copied down the entire data range....

[bw26934]

Wow, Really appreciate it NBVC! Works great!