=G2003 perhaps

or maybe

=INDEX(G:G,2003)

--
HTH

Bob Phillips

"chrisrowe_cr"
wrote in message
news:chrisrowe_cr.1veiqi_1126789546.6274@excelforu m-nospam.com...

Hi all,

Can you lookup based on a row number.

ie the data i want to lookup is in colum G in row 2003

This possible?

Thanks


--
chrisrowe_cr
------------------------------------------------------------------------
chrisrowe_cr's Profile:
http://www.excelforum.com/member.php...o&userid=25220
View this thread: http://www.excelforum.com/showthread...hreadid=467824