I would like to create a list box. My data is in columns A1, B1, and C1 in a
separate spreadsheet. I would like to populate the list with this data. I
would then like to create a formula or macro to give a square footage value
in D1 if A1 is a certain builder name and B1 is a certain house plan and C1
is a certain elevation type then D1 would pull the square footage
automatically. Two builders may have the same house plan name but the square
footage may vary.

Example:
Column A Column B Column C Column D
Builder name House plan Elevation =Square footage
Cardel Anna Maria A
Westfield Arbor B
Winward Anna Maria A