Have 20 categories numbered 1-20 in Column A; have risk factors identified against each 20 categories in Column B. There are 30 potential risk factors that could be assigned that are located in separate sheet, the factors run from -1 to -15 and 1 to 15. Not all will be used. Am trying to lookup all categories with the same risk factor and display the category numbers in single cell. For example in the risk category -1 cell I would like find and display all instances and display 5,14; for risk -2 cell only 1, risk cell -6 would have 13, 17 displayed, etc. These will populating a risk matrix with assigned risk factors that are already assigned. Any ideas, I am pulling my hair out. Thanks.<o></o>
<o></o>
Sample Final Display<o></o>
<TBODY>
</TBODY><o></o>
Categories Risk Factor <o></o>
<TBODY>
</TBODY>
<o></o>
Sample Final Display<o></o>
<o></o> | <o></o> | <o></o> | (RF -2) 1<o></o> | (RF -1) 5,14<o></o> |
(RF-6) 9,17<o></o> | <o></o> | <o></o> | <o></o> | <o></o> |
<o></o> | <o></o> | <o></o> | <o></o> | <o></o> |
<TBODY>
</TBODY>
Categories Risk Factor <o></o>
1<o></o> | -2<o></o> | <o></o> | <o></o> | <o></o> | |
2<o></o> | -10<o></o> | <o></o> | <o></o> | <o></o> | |
3<o></o> | -7<o></o> | <o></o> | <o></o> | <o></o> | |
4<o></o> | 3<o></o> | <o></o> | <o></o> | <o></o> | |
5<o></o> | -1<o></o> | <o></o> | <o></o> | <o></o> | |
6<o></o> | 1<o></o> | <o></o> | <o></o> | <o></o> | |
7<o></o> | 6<o></o> | <o></o> | <o></o> | <o></o> | |
8<o></o> | -4<o></o> | <o></o> | <o></o> | <o></o> | |
9<o></o> | -6<o></o> | <o></o> | <o></o> | <o></o> | |
10<o></o> | -3<o></o> | <o></o> | <o></o> | <o></o> | |
11<o></o> | 13<o></o> | <o></o> | <o></o> | <o></o> | |
12<o></o> | -8<o></o> | <o></o> | <o></o> | <o></o> | |
13<o></o> | -6<o></o> | <o></o> | <o></o> | <o></o> | |
14<o></o> | -1<o></o> | <o></o> | <o></o> | <o></o> | |
15<o></o> | -9<o></o> | <o></o> | <o></o> | <o></o> | |
16<o></o> | -8<o></o> | <o></o> | <o></o> | <o></o> | |
17<o></o> | -6<o></o> | <o></o> | <o></o> | <o></o> | |
18<o></o> | -15<o></o> | <o></o> | <o></o> | <o></o> | |
19<o></o> | -5<o></o> | <o></o> | <o></o> | <o></o> | |
20<o></o> | -13<o></o> | <o></o> | <o></o> | <o></o> | |
<o></o> | <o></o> | <o></o> | <o></o> | <o></o> |
<TBODY>
</TBODY>