+ Reply to Thread
Results 1 to 2 of 2

Index Match Problem

  1. #1
    Registered User
    Join Date
    05-22-2018
    Location
    Scotland
    MS-Off Ver
    2016
    Posts
    1

    Red face Index Match Problem

    Hello!

    I am trying to get excel to return a value and a format of a cell from one sheet to another. I am able to get it to return only the value using formulae like

    =INDEX('Master Comp Matrix '!$D$10:$ET$46,MATCH('Equip Comp Matrix- A1-E'!BA13,'Master Comp Matrix '!$D$10:$D$46,0),MATCH('Equip Comp Matrix- A1-E'!$BH$10,'Master Comp Matrix '!$D$7:$ET$7,0))

    But this does not return the format which is not dependent on the value at all.

    I am not a strong vba user and would greatly appreciate any help on this!! Thanks in advance!!

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Index Match Problem

    What does the formatting signify if it's not value dependent?

    You could have some VBA to find the relevant cell and copy it, content and formatting, rather than using the INDEX/MATCH lookup.
    Or you could have a look around for a UDF to do this for you.

    Perhaps a sample workbook would allow us to understand the issue a little more. That in turn would lead to a solution.

    BSB

+ 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. Formatting with INDEX MATCH MATCH Problem
    By SwissExcel in forum Excel General
    Replies: 1
    Last Post: 07-22-2015, 07:40 AM
  2. [SOLVED] Problem with Index and Match
    By [email protected] in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-25-2015, 12:52 PM
  3. [SOLVED] Index Match Match - syntax problem
    By Dabooka in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-01-2014, 09:05 AM
  4. Replies: 6
    Last Post: 05-28-2013, 05:08 PM
  5. index/match problem
    By pma85 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 05-23-2013, 04:37 PM
  6. [SOLVED] Match-Index Problem?
    By crail5 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-17-2013, 05:30 PM
  7. Problem with INDEX, INDIRECT, MATCH, MATCH
    By JO505 in forum Excel General
    Replies: 5
    Last Post: 09-01-2011, 05:51 PM

Tags for this Thread

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