How to use a Click/List box to bring up values

Hi all

I am new to this, so i hope someone can help

I have attached an excel sheet which i am trying to get data from. on the RASCI sheet has Job Titles, and numbers below the job titles, which will tell me what actions is under what Job title.

On sheet 2

This is where i would need the information
i have put a list box in which gives me the job title and then what i would like is the actions to go under R,A,S,C and I.

If anyone knows how to do this it would help a lot.

The first thing you MUST do is change the title of your thread. People search the forum for solutions. Your title is so vague that any solution will be lost forever. So think google search terms and then amend your title. Your post title should accurately and concisely describe your problem, not your anticipated solution.

To change a Title go to your first post, click EDIT then Go Advanced and change your title.

Hi again. I haven't fully understood what you want... but this is at least partially what you're after. What other columns do you need brought across? This is the array formula used for the R of RASCI.

=IFERROR(INDEX(RASCI!D:D,SMALL(IF(INDIRECT("RASCI!"&ADDRESS(9,MATCH($B$1,RASCI!$A$8:$AS$8,0))&":"&ADDRESS(70,MATCH($B$1,RASCI!$A$8:$AS$8,0)))=5,ROW(RASCI!$D$9:$D$70)),ROWS($1:1))),"")

The 5 is changed to 4 for A, 3 for S, etc.

Array Formulae are a little different from ordinary formulas in that they MUST be confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.

You will know the array is active when you see curly braces { } appear around the outside of your formula. If you do not CTRL+SHIFT+ENTER you will (almost always) get an error message or an incorrect answer. Press F2 on that cell and try again.

Don't type the curly braces yourself - it won't work...

Adjust the big bold values if you add more activities:

=IFERROR(INDEX(RASCI!D:D,SMALL(IF(INDIRECT("RASCI!"&ADDRESS(9,MATCH($B$1,RASCI!$A$8:$AS$8,0))&":"&ADDRESS(70,MATCH($B$1,RASCI!$A$8:$AS$8,0)))=5,ROW(RASCI!$D$9:$D$70)),ROWS($1:1))),"")

Change the big bold letters if you need to add more job titles:

=IFERROR(INDEX(RASCI!D:D,SMALL(IF(INDIRECT("RASCI!"&ADDRESS(9,MATCH($B$1,RASCI!$A$8:$AS$8,0))&":"&ADDRESS(70,MATCH($B$1,RASCI!$A$8:$AS$8,0)))=5,ROW(RASCI!$D$9:$D$70)),ROWS($1:1))),"")

If you run into any problems, post again and (to wake me up) drop me a PM.