I am trying to write a lookup function that will select a rate from an array
(named NIRATES), based on three crireria. What is the neatest way of writing
the function, other than using nested 'IF' statements within OFFSET/VLOOKUP?

My function needs to look something like;
RATE1 ( €œIN€� or €œOUT€�, €œEE€� or €œER€�, lookupdate)

Lookupdate is formatted as YEAR only.

The table looks is held as follows:
Year 1992 1993 1994 1995 1996
OUT:EE 7.00% 7.20% 8.20% 8.20% 8.20%
OUT:ER 6.60% 7.40% 7.20% 7.20% 7.20%
IN:EE 9.00% 9.00% 10.00% 10.00% 10.00%
IN:ER 10.40% 10.40% 10.20% 10.20% 10.20%