Need help scanning a column and getting a return value.

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

A B C
1 10 12
2 2 67
3 45 10
4 2 18
5 4 16

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
 
Disregard the visual example of the columns, i should have checked before
hand for alignment.

mike
 
Mike
A simple answer is to place this formula in cell C1 and copy down to the
bottom of your data.
Then enter into cell E1 the value you are looking for in column A
=IF($E$1=A1,B1,"")
Hope this is what you want
 
Back
Top