Excel Functions

[digital21st]

Hi Guys

I need a function or a formula which can do the following......

I have two worksheets.

One worksheet has a list of names in a set order that can't be changed.

The other worksheet has the same list of names in alpabetical order with a value next to the name in a seperate column.

I need to grab the value from the second sheet and insert it next to the same name in the first sheet..

I hope that made sense

Thanks in advance

Digital

[Bondi]

digital21st wrote:
> Hi Guys
>
> I need a function or a formula which can do the following......
>
> I have two worksheets.
>
> One worksheet has a list of names in a set order that can't be
> changed.
>
> The other worksheet has the same list of names in alpabetical order
> with a value next to the name in a seperate column.
>
> I need to grab the value from the second sheet and insert it next to
> the same name in the first sheet..
>
> I hope that made sense
>
> Thanks in advance
>
> Digital
>
>
> --
> digital21st
> ------------------------------------------------------------------------
> digital21st's Profile: http://www.excelforum.com/member.php...o&userid=29575
> View this thread: http://www.excelforum.com/showthread...hreadid=561970

Hi,

It sounds like you can use VLOOKUP()

Something like:

=VLOOKUP(NameInSheet1,ArrayOfNamesAndValuesOnSheet2,2,False)

So maybe like:

=VLOOKUP(A1,Sheet2!$A$1:$B$10,2,FALSE)

And copy down next to your list of names on Sheet1

Regards,
Bondi

[digital21st]

Cheers Bondi

It worked a treat.

Regards

Digital

[Gary]

=VLOOKUP(A1,Sheet2!$A$1:$B$10,2,FALSE)

copy down.

"digital21st" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi Guys
>
> I need a function or a formula which can do the following......
>
> I have two worksheets.
>
> One worksheet has a list of names in a set order that can't be
> changed.
>
> The other worksheet has the same list of names in alpabetical order
> with a value next to the name in a seperate column.
>
> I need to grab the value from the second sheet and insert it next to
> the same name in the first sheet..
>
> I hope that made sense
>
> Thanks in advance
>
> Digital
>
>
> --
> digital21st
> ------------------------------------------------------------------------
> digital21st's Profile:
> http://www.excelforum.com/member.php...o&userid=29575
> View this thread: http://www.excelforum.com/showthread...hreadid=561970
>