Find multiple matches in other sheet column return row data
sorry I don't understand.
Why do you want to bring the data ometimers to column A and sometimes to
C?
Can you show me the layout of the tables and the expected result if a
Nme occurs more than once?
Sure, I believe this will show it.
Actually I am open to how the data comes back to Input, But I want to keep original Input sheet column A intact and list the results in column C.
I suspect there will need to be a sort to group the same Nme's together. My example has numbers but the real data will most likely be just words.
I limited rows of data but there will be about 41+- on Output.
Sheet Input column A
Header
input-1
input-2
input-3
input-4
input-6
input-8
input-10
input-11
input-12
input-13
Sheet Output Col A - D (40+- more rows)
Header
input-1 data 1 and More cells
input-2 data 2 and More cells
input-3 data 3 and More cells
input-1 data 4 and More cells
input-5 data 5 and More cells
input-6 data 6 and More cells
input-7 data 7 and More cells
input-8 data 8 and More cells
input-9 data 9 and More cells
input-10 data 10 and More cells
input-11 data 11 and More cells
input-8 data 12 and More cells
input-13 data 13 and More cells
input-13 data 14 and More cells
Sheet Input results
Header
input-1 input-1 data 1 and More cells
input-2 input-1 data 4 and More cells
input-3 input-2 data 2 and More cells
input-4 input-3 data 3 and More cells
input-6 input-6 data 6 and More cells
input-8 input-8 data 8 and More cells
input-10 input-8 data 12 and More cells
input-11 input-10 data 10 and More cells
input-12 input-11 data 11 and More cells
input-13 input-13 data 13 and More cells
input-13 data 14 and More cells
Hope the format hold together.
My Drop Box is down with some sort of problem.
Howard
|