I bet you want to use =vlookup().

Debra Dalgleish has some nice instructions at:
http://www.contextures.com/xlFunctions02.html

George A. Yorks wrote:
>
> Trying to create a formula to do the following:
> Sheet 1 column A a list of personal names a1-a10
>
> Sheet 2 has list of names a1-a10 and list of dollar amounts colums d1-d10
>
> want to search sheet one and if any name from sheet 2 found on sheet 1 than
> the corresponding dollar amount is entered.
>
> Any help appreciated.
> --
> George

--

Dave Peterson