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