In need of some Excel help. I have used a budget template. I have created a drop down menu for the participants (C3) but I am unsure how to link it to the data on the right. The you graph will change according to what is entered in risk (C5). What I would like to do is be able to select a participant and cells C5, C6, & C7 change according to the data stored on the right hand side (and obviously change the you graph according to what entry is in C5).
Can it be done? Many thanks.
EDIT - I have just been informed VLOOKUP should fit the bill.
EDIT 2 - Please delete, think I have done it.
EDIT 3 - vlookup is amazing!!!!
Can it be done? Many thanks.
EDIT - I have just been informed VLOOKUP should fit the bill.
EDIT 2 - Please delete, think I have done it.
EDIT 3 - vlookup is amazing!!!!
Last edited: