Use dollar signs to lock the rows on your lookup range (A$1:A$3) before you
fill down the column.

--
Carlos

"trafficbroker"
wrote in message
news:trafficbroker.252pon_1143034803.1019@excelfor um-nospam.com...

Ive just been studying the formula and the problem is that when i drag
down the formula to my other values it changes the lookup cell to
match. Hence the lookup value is incorrect if it has been copied down a
larger data set.

Is there anyway to get around this do you think?


--
trafficbroker
------------------------------------------------------------------------
trafficbroker's Profile:
http://www.excelforum.com/member.php...o&userid=28710
View this thread: http://www.excelforum.com/showthread...hreadid=525232