I'd add headers to the data in row 1.

Then I'd filter the range (data|filter|autofilter in xl2003 menus).

Then I'd filter column A to show the 123's and filter column B to show the 45's.

Data|Filter|show all
will show all the data quickly.

wrote:

If I have data "123, 45" (ie, 123 in cell a1 and 45 in b1
How can I search for "123 45"?

- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist
http://www.facebook.com/vasjpan2
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Remorse begets zeal] [Windows is for Bimbos]

--

Dave Peterson