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