I have created an excel workbook. On one page I have an item list numbered from 4100 to 6000. Each item has a description and a corresponding rate.
Then I created an estimate page. I want to enter an item number on the estimate page and get the corresponding description and rate on the estimate.

I need a formula that will allow me to do this.