Results 1 to 12 of 12

How to Bring back the Value of the top of the column

Threaded View

  1. #1
    Registered User
    Join Date
    07-23-2015
    Location
    Barcelona
    MS-Off Ver
    2016
    Posts
    19

    Unhappy How to Bring back the Value of the top of the column

    Hello Guys

    I have been struggle myself trying to do a sort of (offset, Index or whatever)
    What I basically need to do is return the value that is in the top of the column
    Like I was doing a kind of (un-offset)


    In the spreadsheet attached there is a list of people and jobs that they were on
    When I chose a job number I need to bring back who was on that job, there is always more than one person in the same job

    I attached the spreadsheet

    Can anybody help me, please?
    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. [SOLVED] Find value that doesn't match and bring back column heading
    By Keelin in forum Excel General
    Replies: 20
    Last Post: 02-13-2015, 10:16 AM
  2. Bring Back Most Frequently Used Word in a Column
    By martinpgibson in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-14-2014, 05:34 PM
  3. Array Formula Lookup - Bring back Lowest Date + Bring Back Cell Location
    By Matt1998 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-04-2014, 12:08 PM
  4. [SOLVED] Stop Vlookup bringing back 0's or #REF! and bring back blanks instead
    By Carling73 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-30-2013, 04:43 PM
  5. [SOLVED] Bring back a name in one column based on criteria in 2 other columns
    By BillDoor in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-22-2013, 08:07 AM
  6. Replies: 0
    Last Post: 01-29-2013, 01:46 PM
  7. Bring back the old help format!
    By John Przybylski in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-05-2005, 02:06 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