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
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
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
Bruce
The older I get, the better I used to be.
USA
=G2003 perhaps
or maybe
=INDEX(G:G,2003)
--
HTH
Bob Phillips
"chrisrowe_cr" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks