+ Reply to Thread
Results 1 to 1 of 1

match index and if for file link

  1. #1
    Forum Contributor
    Join Date
    08-07-2018
    Location
    india
    MS-Off Ver
    2007
    Posts
    233

    match index and if for file link

    HI EVERYONE.
    i have file in which i have scheduled the cleaning tasks of machine and it's parts.
    there are two type of cleaning first on regular basis and second on particular occasion.
    which i am going to handle with google forms. for daily cleaning schedule there is sheet "form responses 5" which belongs to sheet 1! row no. 12-13.

    and row no. 14-15-16 belongs to form responses 1. data of row no. 14-15-16 will be occasionally.
    everything is fine. only what i want is that this sheet should be automatic.

    in row 11 every column which contains "P" has a formula. (please check the formula, if i will elaborate here, it will become a mess.) so my requirement is that in row 11 where ever is the column of "work". it should be auto fill with "normal", "cotton ", chenille".

    and in row 11 where ever column of "before" and "after". their regarding link should also filled by itself there.

    for more result please see sheet desire result. any changes will also be acceptable but want to have this as solved
    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. How to link INDEX MATCH with date range?
    By Paulinho in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 11-13-2019, 11:15 AM
  2. Link Formatting of Another Cell That Is Found Using Index, Match, and Conditional
    By wayum999 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-24-2019, 10:49 PM
  3. Trouble with using MATCH INDEX to link cells from other sheets
    By apples02 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-30-2015, 11:13 PM
  4. [SOLVED] Link data validation to other cells, index match
    By chance0410 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-02-2013, 03:49 AM
  5. Can you use the INDEX MATCH function to send a hyper link?
    By ckgeary in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-12-2013, 03:20 PM
  6. [SOLVED] Index-match link directly to excel
    By puuts in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-06-2013, 09:45 PM
  7. VLOOKUP INDEX MATCH then copy paste / Link?
    By alleyb in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-13-2011, 02:01 PM

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