How do I retrieve & view multiple matches from another workbook?

[Michael]

For example: I have one certain number that shows up mulitple times on
another workbook. I need the formula to retrieve and view ALL matches to my
one certain number.

 

[Niek Otten]

http://office.microsoft.com/en-us/assistance/HA012260381033.aspx

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| For example: I have one certain number that shows up mulitple times on
| another workbook. I need the formula to retrieve and view ALL matches to my
| one certain number.
|