Match Index Choose

[Gav !!]

Folks

I am trying to work out the formula which would return to me the result
based on an intersection of 3 sets of values 1 horizontal and 2 vertical

eg..

on Sheet2 I have values each in a seperate cells

2003 2003 2003
2003
1 2 3
4
jan feb mar
apr
value1 a b c
d
value2 e f g
h
value3 i j k
l

Now on sheet1 I have a list down the page ( A column ) of a date and the
value name ( B column ), from that I have extracted the month number (G
column) and year number ( H Column)
What I want to do is put a formula on sheet1 that will look at the value
name (a) and the month (g) and year(h) and look up the corresponding value
on sheet 2 and return it for me. If you want to use an array name or table
name for sheet 2, fine, except that there isn't any data in A colmn above
value1.

Hope this makes sense and thanks in advance

Regards

Gav !!

 

[Frank Kabel]

Hi
one question: On sheet 2 how are the years separated. That is:
- has each year the same amount of rows
- is there a line between the years

In General I would suggest you change the layout of sheet 2 so that you
have the year+month as heading