I'm creating an excel document to record all the statistics from a driving championship but I've run into a problem, this is hard for me to explain but I'll do my best...

On a worksheet called 'DriverStats', I have a drop down menu made up of all of the drivers names, and depending on the driver selected in the drop down menu all of the stats on this worksheet change appropriately.

But, I now want another worksheet 'Tables', which displays stats for several drivers together. If I make a reference to the 'DriverStats' worksheet, then of course the value returned depends on whoever happens to be selected in the drop down menu.

Is there a way of referring to a cell on the 'DriverStats' worksheet, AND tell excel to return the value based on a specific selection from the drop down menu on that worksheet?

I hope that is clear heh

Any help would be much appreciated.

Cheers,
Dave.

Hi Dave,

Can you have a series of columns, one for each diver you wish to compare?

Use Data Validation to select the Diver Name in say row 2.

Your field headers in Column A.

Formulas liking Data and the name in row 2.

HTH

Educo.

Happy to help offline if that's easier.