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


--
spikk
------------------------------------------------------------------------
spikk's Profile: http://www.excelforum.com/member.php...o&userid=24932
View this thread: http://www.excelforum.com/showthread...hreadid=384691