+ Reply to Thread
Results 1 to 2 of 2

Index/Reference/Match Question

  1. #1
    Registered User
    Join Date
    06-07-2012
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    24

    Index/Reference/Match Question

    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!

    Problem Example.xlsx

  2. #2
    Forum Contributor
    Join Date
    07-24-2009
    Location
    Valrico, FL USA
    MS-Off Ver
    Excel 2016
    Posts
    358

    Re: Index/Reference/Match Question

    Try the attached file.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Index, match, match Question!. Seems so simple but can't figure it out...
    By huikimhuikim in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-12-2013, 01:57 PM
  2. #Value error when using INDEX and MATCH to reference a cell
    By willow77 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-01-2013, 08:56 AM
  3. Using INDEX MATCH to reference multiple sheets
    By myshadeofglory in forum Excel General
    Replies: 3
    Last Post: 10-22-2011, 07:31 AM
  4. Using INDEX MATCH to reference a cell that has a CONCATENATE
    By myshadeofglory in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-17-2011, 01:40 PM
  5. MATCH/INDEX to reference three cells against each other?
    By johnmitch38 in forum Excel General
    Replies: 3
    Last Post: 10-03-2011, 11:17 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1