Hi all,

New to VBA and tried looking in a lot of places so apologies if this has been answered elsewhere.

I have two drop down lists on a spreadsheet and a button entitled 'enter'. What I want to happen is for when the user clicks 'enter' some text appears in the same row but a few columns right of a row specific to the data in row A.

So:

In cell G3 I have a drop down list called 'names' which references cells A3:A32 (a class list). And in cell G4 I have another drop down list which has a range of possible intervention strategies in a short code (eg. DT for BfL). This is stored in a table to aid data validation and there is a last column in the data validation table which is the full term for the intervention short code (eg. "A number of detentions set as a result of poor Behaviour for Learning").

The data validation table is as follows:
Intervention_tbl6 - refers to ='Pro Int Template T1!'$H$2:$J$31
PupilNames_dd - refers to =Intervention_tbl6[Names]
InterventionShortCode_dd = refers to =Intervention_tbl6[Intervention short code]
$J$2:$J$31 has the full terms for the intervention short code so if using VLOOKUP for example it would be in the column next to the short code.

My aim is for a user to select a name in the drop down in G3, select a code in G4, click enter and for the full term to appear in column F in the same row as the name that the user selected. (eg. User selects A.N.Other who appears in row 15, user selects 'DT for BFL' and "A number of detentions set as a result of poor Behaviour for Learning" appears in cell F15 once they have clicked enter.

Hope that makes some sense! If anyone could point me in the direction of an example of what I'm looking for or has any tips I'd be very grateful!

Thanks in advance.