first a number does not mean anything text and values is
how you need to think
What I think you want is to popluate the cell
lets
1234 street, has a city of Dallas and st of TX
are wanting to type
1234 St into column
and then the st and zip appear in col b and c
wright me back

"Mike" wrote:

Both columns consist of hundreds of numbers. What i need to do. I need to
scan Column 'A' for a certain number, once that number is found, it puts the
number directly next to the number (the number in Column 'B') into Column
'C'.

Let me give an exact example. I want to scan Column 'A' for the number '2'
once a '2' is found it places the number directly next to the number 2 in
Column 'C'.

A summary, scan Column 'A' for a specific number, once that number is found
it takes the number in Column 'B' (which is next to the two in 'A') and
places the number found in Column 'B' into Column 'C'.

I hope this is possible.

Thanks