Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Need help scanning a column and getting a return value.
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Need help scanning a column and getting a return value.
Disregard the visual example of the columns, i should have checked before
hand for alignment. mike |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Need help scanning a column and getting a return value.
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 "Mike" wrote: Disregard the visual example of the columns, i should have checked before hand for alignment. mike |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Need help scanning a column and getting a return value.
One other guess
In C1: =IF(A1=2,B1,"") Copy down to last row of data in col B -- Max Singapore http://savefile.com/projects/236895 Downloads:21,000 Files:370 Subscribers:66 xdemechanik --- "Mike" wrote: Disregard the visual example of the columns, i should have checked before hand for alignment. mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return text in Column A if Column B and Column K match | Excel Worksheet Functions | |||
Scanning | Excel Worksheet Functions | |||
LOOKUP and return the column heading for IF/THEN return for False | Excel Discussion (Misc queries) | |||
Scanning down a column | Excel Discussion (Misc queries) | |||
scanning a table? | Excel Worksheet Functions |