I am attempting to automate a portion of a risk analysis process for my job. I would like to automate the process of pulling codes into a matrix and placing them based on risk calculations. I have assigned each quadrant in the matrix a number (1-25) and used a series of if statements to assign each code a quadrant number. I then want to use a VLookup type formula to pull each code into the appropriate quadrant cell and seperate multiple codes in the same cells with commas. However, VLookup will only pull the first code for a quadrant and will drop all others. I have done a lot of research and it seems that I need to use the index and match functions, or a LookupAll funtcion. Unfortunately, I have tried a multitude of times and can't get either function to work. The data set is two columns. In column A (the quandrant numbers) a data set could be any numbers 1-25 depending on the risk calculations (typically would have several duplicates). Column B would have unique codes (one alphanumeric, two numeric) that need to be pulled into the matrix. I listed an example data set below. I've also attached the workbook. If anyone could tell me how to pull the codes in column B to cells based on the correlating data in column A while allow the function to pull codes with duplicates in column A and display them in the same cell seperated by commas I would really appreciate it. Thanks, Mark.
Column A -
2
13
14
9
5
25
22
9
13
9
Column B -
S01
S02
S03
S04
S05
C01
C02
C03
C04
C05
Bookmarks