Excel cell search and enter value

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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!



1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
use vlookup