| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find cell and copy value to column to the right
Hi,
I have an unsorted list with data in columns A:J. I would like to lookup a value that is listed in column K. If the data is found, the value directly to the left of the found cell should be listed in column L. If found more than one time, the information must be separated by a comma. A B C D etc K L 100 101 102 103 etc 102 101 Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find cell and copy value to column to the right
Things have changed. If found, I need the value(s) that is (are) in
column H. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maddening Dilemma - Compare each cell within column a to each cell in column b and find unique matches | Excel Worksheet Functions | |||
| FIND LAST COPY OF A TEXT IN A COLUMN | Excel Discussion (Misc queries) | |||
| Find last column, move formulas over, copy/paste data | Excel Worksheet Functions | |||
| Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
| copy and pasting a find all list into another column | Excel Discussion (Misc queries) | |||
Linear Mode
