lookup based on a row number
 

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

=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

What do you mean "lookup"? As in VLOOKUP or HLOOKUP? Are you using
this in a formula? What do you want to do with the value in G2003?

More details, please.

Bruce


--
swatsp0p


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