Just a further note: I am assuming INDEX function is based on A1. Adjust
row/column calculations as required for different INDEX base.

"Bondi" wrote:


Hi Rianne,

If the above table starts in A1 (Provider 1 in B1 and Age in A2) then i
think something like this formula will work for picking out Provider 1,
Attribute 8 and 4-7 years:

=VLOOKUP("Attribute8",A3:I11,MATCH("Provider 1",B1:I1)+MATCH("4-7
years",B2:I2),FALSE)

Regards,
Bondi