Excel cell search and enter value

Closed
formula frustrated - Dec 1, 2011 at 03:22 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 1, 2011 at 06:10 PM
Hello,

I need help constructing a formula in Excell 2007 that will do the following
- search the spreadsheet for matching number
- if it finds the number input the amount corresponding with that number which is in the next cell

Example in cell A1 is employee number 12345, in cell D432 is the same number. I need to copy the amount that is in cell E432 and input into cell B1. Is there a formula that I can put into cell B1 to do this?

Thanks so much!



Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Dec 1, 2011 at 06:10 PM
use vlookup
0