The way I do it is to have a line of numbers (37,38,39,40,41, etc etc)
and reference off that, so your formula would look like:

=HLOOKUP($A$3,Apr!$G$4:$AQ$300,D3,0)

You just need to put the dollar signs in the appropriate place. I can
never remember which way round they go!

HTH,

Chris


--
Tibbs
------------------------------------------------------------------------
Tibbs's Profile: http://www.excelforum.com/member.php...o&userid=15947
View this thread: http://www.excelforum.com/showthread...hreadid=530894