getting data from one sheet to another using a droplist

--------------------------------------------------------------------------------

Hi everyone, first post here.

I have uploaded my Excel File . it is 26kb

I have a test tomz at uni, and i need to be able to bring data from another sheet (sheet 1) from a droplist box on another sheet (sheet 3). These are just sales figures for a motorbike boots (my assignment). I have made the drop downlist that has all the "sales agents" in it, but i need to know how to make it so when you click one "agent" the data comes from sheet 1 and brings up the relevant sales information.

I assume that VLOOKUP() is needed here, i have used it in previous sections of my file.

I have started putting the headings and needed columns on sheet 3.

If anyone could help me here, i would really appreciate it.

thanks,
Ady

Re: getting data from one sheet to another using a droplist

OMG! thank you so much brister that is exactly what I needed.
i was trying for hours last week to do that. but I tried using VLOOKUP in the actual drop down box, i didn't think you actually had to do it in the boxes.

once again i really appreciate it.

and also, to change it so commission only comes up in one of the boxes say cell 'C5' on sheet 3, i just delete the formula used in C6 and C7?

anyway im sure ill figure out,
thanks alot