looped functions

[sanders]

Hi,
Is it possible to create a looped function where excel looks down a list for a (non-numerical) value and then returns the row associated to it to a different worksheet?


Thanks

[Miguel Zapico]

Check the help for the MATCH function, it may fit on what you need.

Miguel.

"sanders" wrote:

>
> Hi,
> Is it possible to create a looped function where excel looks down a
> list for a (non-numerical) value and then returns the row associated to
> it to a different worksheet?
>
>
> Thanks
>
>
> --
> sanders
> ------------------------------------------------------------------------
> sanders's Profile: http://www.excelforum.com/member.php...o&userid=36745
> View this thread: http://www.excelforum.com/showthread...hreadid=565971
>
>

Hi

From your description, I would suggest you have a look at VLOOKUP. It will
find a value in a column and return a value from along its row.
Post back with more information if you need any more help.

Andy.

"sanders" <sanders.2bnpee_1154091905.3297@excelforum-nospam.com> wrote in
message news:sanders.2bnpee_1154091905.3297@excelforum-nospam.com...
>
> Hi,
> Is it possible to create a looped function where excel looks down a
> list for a (non-numerical) value and then returns the row associated to
> it to a different worksheet?
>
>
> Thanks
>
>
> --
> sanders
> ------------------------------------------------------------------------
> sanders's Profile:
> http://www.excelforum.com/member.php...o&userid=36745
> View this thread: http://www.excelforum.com/showthread...hreadid=565971
>