Excel question selection tool (interviews) - help?

[nicolas2465]

Hi, I need to build this tool for work and to be completely honest I don't have the excel skills.  My boss won't pay for someone to do it profesionally and IT is too busy.

 

I am building a tool for recruiters to select questions for the interview and write their notes based on a selection of the position level of the job (in Front End sheet) which would then auto-populate competency fields, with options to add optional ones. The questions are not finalized but the required competencies for each level (there are 3 brackets) are identified in the sheet "Position Levels".

 

I'd like to get rid of the sheet "List" and instead based on formulas auto-populate competency fields and the available questions to choose from based on those all within the Front End sheet, and then what you select would show up on the front page. The database for competency selection and associated interview questions should be in the "Question Database" sheet. If you can think of a better way to do it I am all ears.  Maybe I am thinking about it the wrong way.

 

Basically, I just want recruiters to get specific competencies with their associated questions to choose from based on if they choose levels 1-6, 7-8, or 9-12

Interview Grid DDI - Level competency selection V2.xlsx

[LogicalDrm]

Check on if using VLOOKUP and HLOOKUP would work. For example, VLOOKUP watches entries in column and then populates based on those values and what their corresponding values are in another sheet.

 

As I'm not power user with Excel, I don't know how well that works with dropdown selections. Its perfect for my needs where I need to carry names and their corresponding point values over multiple sheets.