lookup table

insert a new worksheet (right-click any sheettab and choose Insert, select worksheet).

Then create a table.

First column lists the colleges, next columns list relevant information for each college.

Then you can use a Vlookup() formula in the selection sheet that will pull up the info from the lookup table. You can use data validation (with a list refering to the first column in your new sheet) to prevent users from entering a college not in your list.

Check Excel help files on Vlookup and Data Validation.

You zipped a link to the file, not the actual spreadsheet itself. Retry zipping the Excel file.

Originally Posted by soliver0012

Apparantly I didn't know how to do that either. I tried again, hope it works

Can you please re-iterate what you need?

Also, I don't see where the college choice (drop-down menu) is being made?

How would one make a college choice, then?

Where is the list of colleges?

So, in a new worksheet, one enters (or selects) a college, and beside that selection comes all the costs from Costs sheet? (I am assuming you only want the total costs for those 3 categories)?

Have a look at the attached and see if it is what you need.

I created a sheet called Choices and in column Q I listed the colleges from your Costs sheet and named the list "Colleges". You can move this list anywhere you want or hide the column.

I then created a Data Validation drop down list in B2 which references that list. When you click on this cell you get a list to choose from. If you try typing something in, it will give an error.

Once the choice is made, the corresponding tuition, clothing and entertainment costs populate.

Hope this is what you were looking for.

Regards.

I'm glad to help.

The only thing that changes in the formulas for the other items in the Indexing column. See attached.

Another key is to have consistent table size. The Virginia Polytechnical Institute and State University section included an extra row. I put the State University part with the first part and deleted an empty row to keep consistency....you will also have to update the Colleges list in column Q of the Choices tab.

Good Luck.