Hi, I'm new to excel programming and will start learning today.

My first task is to extract data by entering an id number in a cell that would pull data corresponding to the ID.

Cell A1 contains the ID numbers which is 1.
Cell B1 contains the data corresponding to the ID number which is data of 100.

I need to do this:
Cell D1 enter an ID number (example: 1)
Cell E2 will see result of 100.

I have many many rows of data and would like such a function to retrieve data when entering a ID number to retrieve data corresponding to that ID.

How would I do this? I tried playing with simple excel if then statements but it won't nearly do what I need. Help!