Hi there,

I am wondering what the best way to go about the following scenario
is.

I have three different worksheets in my workbook
Sheet 1 is my input sheet
Sheet 2 is my analysis sheet (analyses everything that is put in Sheet
1)
Sheet 3 is my Building information sheet

Sheet 3 contains a table with different buildings and their
information:
For example
A: Building Name
B: Rental Rate
C: Square Footage
D: Commission

I created a lookup field in my input sheet where only Building names
listed on Sheet 3 can be chosen.

I would like for sheet 1 to automatically grab Rental Rate, Square
Footage, Commission and fill in those fields based upon the selection
of the building name.
I have a total of about 20 Buildings that I would like to enter.
Thanks for your help!