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?
