+ Reply to Thread
Results 1 to 4 of 4

vlookup and match gremlin

  1. #1
    Registered User
    Join Date
    01-17-2020
    Location
    UK
    MS-Off Ver
    2016
    Posts
    43

    vlookup and match gremlin

    Hi lovely forum,

    I have vertical column list with descriptors in column B on the config tab.

    Against these descriptors are certain tasks which also relate to these.

    On the data input tab I have attemped to do (wrongly) a vlookup match for these.

    What I would like assistance with is a conditionally formatted cell of amber colour which shows up against the corresponding input of 1 on the config tab.

    Hope that makes sense?

    Thanks in advance
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,027

    Re: vlookup and match gremlin

    The formula in D2 should be
    =VLOOKUP($B2,'Config 1'!$B$2:$AP$40,MATCH(D$1,'Config 1'!$B$1:$AP$1,0),FALSE)
    Then you can use
    =D2=1 as the formula for the condition format.

  3. #3
    Registered User
    Join Date
    01-17-2020
    Location
    UK
    MS-Off Ver
    2016
    Posts
    43

    Re: vlookup and match gremlin

    Thankyou Fluff

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,027

    Re: vlookup and match gremlin

    You're welcome & thanks for the feedback.

+ 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. Gremlin with decimal places after input
    By J8Colt in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 11
    Last Post: 11-15-2019, 11:39 AM
  2. Gremlin with decimal places after input
    By J8Colt in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-15-2019, 09:03 AM
  3. Replies: 1
    Last Post: 06-18-2015, 08:45 AM
  4. [SOLVED] Vlookup to Pivot Table, using Match function, returns error if can't find match value
    By AndrewHowarth in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-16-2015, 12:10 AM
  5. Replies: 3
    Last Post: 05-19-2014, 02:01 PM
  6. Replies: 13
    Last Post: 12-13-2012, 11:44 AM
  7. Replies: 2
    Last Post: 03-16-2012, 12:03 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