I am trying to lookup two values and then find the corresponding value from a matrix.
the list is very very long and has a column for code, a column for time of day and a column of minutes.
Code TOD Mins
p2 Std 45678
p2 Eve 56430
p2 Wkd 32223
they are not always in the order of std eve wkd. And some instances there may be just one time of day against a code,
so in the matrix is the time of day along the columns say b to d ;
Std Eve wkd
in the rows are the codes say p6 p2 p0
and then in the matrix are the rates
Std Eve Wkd
p6 3.5 2.5 1.5
p0 9.0 7.5 3.9
p2 4.8 3.0 2.1
i have tried to get to grips with offset and match but cannot get it to work right.
any advice would be helpful.
Regards
Spikk
Bookmarks