George,
In B1 of sheet 1:
=VLOOKUP(A1, 'Sheet2'!$A$1:$B$10, 2, FALSE)
Copy down with fill handle to B10.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------
"George A. Yorks" .(donotspam) wrote in message
...
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
|