Results 1 to 5 of 5

Lookup Column Header based on cell value

Threaded View

kingcal Lookup Column Header based on... 08-11-2009, 12:31 PM
NBVC Re: Lookup Column Header... 08-11-2009, 12:34 PM
kingcal Re: Lookup Column Header... 08-12-2009, 06:35 AM
NBVC Re: Lookup Column Header... 08-12-2009, 09:14 PM
kingcal Re: Lookup Column Header... 08-13-2009, 03:56 AM
  1. #1
    Registered User
    Join Date
    02-22-2007
    Posts
    10

    Lookup Column Header based on cell value

    Hi,

    Hoping to tap into your collective experience to help me with this! I have a spreadsheet an excerpt of which is as follows:

    K L M N
    1 Doors Security Vehicle Key
    2 TRUE FALSE FALSE FALSE
    3 FALSE TRUE TRUE FALSE
    4 FALSE FALSE FALSE FALSE

    Want I want to happen is to return the column header where there for a cell which contains "TRUE" in a blank column. If there isn't a cell with the value "TRUE" then to return "N/A". In the above example in blank column P for Row 2 would be "Doors", Row 3 would be "Security,Vehicle" and Row 4 would be "N/A".

    In my actual spreadsheet I have 12 columns (L to W) which have the TRUE or FALSE values.

    I know it has something to do with either HLOOKUP, INDEX and MATCH but can't seem to get it right. Any ideas?
    Last edited by kingcal; 08-13-2009 at 03:56 AM.

Thread Information

Users Browsing this Thread

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

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