If the range is A1:G100, for example, and age is in H1 and event in H2:
"MS_user" <MSuser@discussions.microsoft.com> wrote in message
> from a standard spreadsheet, using a function(?) how can I return a value
> from a table using values for the headers and columns. For example, the
> has ages across the top and events done the side. Simply I need to
> both ages and events to return a value from the cross section of these
> Any assistance welcome!!
> Many thanks