I have two sheets that I want to link together for appraisal purposes, and have not been able to find a efficient way to do it so far.. One sheet is an input sheet which I manually fill in everything, and I want those values to feed into the other sheet in a very specific way.
In the example workbook that Ive uploaded, the sheet which I manually input information is labeled "Info". On this sheet I have the first column labeled "Dock" with each docks specific information (type, length, width, # available) in the adjacent columns. The sheet I want this information to flow into is labeled "Start". In the first column, I have created a data validation list that allows for me to select which dock I am analyzing. I want to create a formula that allows for all the docks information from "info" sheet to automatically flow in to the adjacent columns on "Start" when the value I select from the data validation list matches a dock name from "info".
This is a little confusing, so looking at the example will help alot. As of now, all the information is where I want it to be, I just want to create a formula that will do everything automatically so all I have to do is type in the information on "info", and then select which dock I'm looking at on "Start".
Thank you so much for taking a look!
Re: Index/Reference/Match Question
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By huikimhuikim in forum Excel Formulas & Functions
Last Post: 06-12-2013, 01:57 PM
By willow77 in forum Excel Formulas & Functions
Last Post: 01-01-2013, 08:56 AM
By myshadeofglory in forum Excel General
Last Post: 10-22-2011, 07:31 AM
By myshadeofglory in forum Excel Programming / VBA / Macros
Last Post: 10-17-2011, 01:40 PM
By johnmitch38 in forum Excel General
Last Post: 10-03-2011, 11:17 AM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1