Results 1 to 4 of 4

lookup column header based on cell value found from row name

Threaded View

mtwa1990 lookup column header based on... 10-06-2020, 12:54 PM
mehmetcik Re: lookup column header... 10-06-2020, 02:11 PM
Bo_Ry Re: lookup column header... 10-06-2020, 02:29 PM
mtwa1990 Re: lookup column header... 10-06-2020, 02:47 PM
  1. #1
    Registered User
    Join Date
    05-11-2019
    Location
    Leicester, England
    MS-Off Ver
    Office 365
    Posts
    52

    lookup column header based on cell value found from row name

    I have had a search around and i cant find what im looking for as i dont know how to describe it well.

    I have a holiday tracker for my staff i have their names listed down the first column and dates across the top. Each holiday is marked as H and Bank Holidays as BH.

    What i would like is from that information a formula that i can put in a cell below a staff members name, the formula will find "H" in the corresponding row and show me the date, if i pull down that formula to the next few cells then each cell will find the next H and display the date etc

    This will list all the dates a member of staff has booked off by just entering a H into the row hopefully the attached doc will help with the understanding of what i need.

    Thank you for any help
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA to Lookup all Rows based on Column Header
    By matt85webb in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-14-2018, 07:23 PM
  2. macro to lock cell by column header based on value in another cell by column header
    By Closet Guru in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-03-2015, 12:36 PM
  3. Using Lookup? Index match? to populate cells based on column header
    By NoExcelSkills17 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-15-2015, 03:50 PM
  4. [SOLVED] Create Dynamic Column Lookup Reference based on Table Header
    By jeversf in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-22-2013, 12:49 PM
  5. Lookup Column Header based on cell value
    By kingcal in forum Excel General
    Replies: 4
    Last Post: 08-13-2009, 03:56 AM
  6. Replies: 1
    Last Post: 01-30-2009, 07:40 PM
  7. Lookup a column header based on first column with value >0
    By jasonanthony in forum Excel General
    Replies: 1
    Last Post: 01-28-2009, 08:53 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