Sorry Bob, perhaps my last post was not correctly phrased,
I understand everything about the formulae apart from the match type,

I have attached a word document with some screen shots because i thin
i may be explaining the problem incorrectly.

The first doc appropriately named help! shows the formulae in the ba
and the cell i am trying to reference. The week commencing in yello
should have a concession value of 12.5.

The second doc shows where i want to match the data to.

Any help will be much appreciated. Cant get my head around this one
netiher can the IT dept at a world wide manufacture believe it or not!

Thank

+-------------------------------------------------------------------
|Filename: Printed#.doc
|Download: http://www.excelforum.com/attachment.php?postid=3596
+-------------------------------------------------------------------

--
PaulOakle
-----------------------------------------------------------------------
PaulOakley's Profile: http://www.excelforum.com/member.php...fo&userid=2510
View this thread: http://www.excelforum.com/showthread.php?threadid=38672