+ Reply to Thread
Results 1 to 5 of 5

Give me a cell value of a column where search value is found

  1. 02-19-2018, 07:54 AM #1
    petar256 is offline
    Registered User
    Join Date
    06-20-2014
    Location
    Croatia
    MS-Off Ver
    2010
    Posts
    17

    Give me a cell value of a column where search value is found

    So..I have a code that works. It searches a value in a whole sheet. When it finds it I want to give me the header(Title) of the column where that value is.The title(header) is in third row for every column.


    Please Login or Register  to view this content.

    ATTACHED EXAMPLE
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-19-2018, 08:26 AM #2
    Sintek is offline
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: Give me a cell value of a column where search value is found

    Perhaps...
    Please Login or Register  to view this content.
    Last edited by Sintek; 02-19-2018 at 08:30 AM.
    Good Luck...
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
    Also....Add a comment if you like!!!!
    And remember...Mark Thread as Solved...
    Excel Forum Rocks!!!
    Reply With QuoteRegister To Reply
  3. 02-19-2018, 08:26 AM #3
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,251

    Re: Give me a cell value of a column where search value is found 

    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  4. 02-19-2018, 08:50 AM #4
    petar256 is offline
    Registered User
    Join Date
    06-20-2014
    Location
    Croatia
    MS-Off Ver
    2010
    Posts
    17

    Re: Give me a cell value of a column where search value is found

    Quote Originally Posted by sintek View Post
    Perhaps...
    Please Login or Register  to view this content.
    Offcourse. Thank you
    Reply With QuoteRegister To Reply
  5. 02-19-2018, 09:28 AM #5
    Sintek is offline
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: Give me a cell value of a column where search value is found

    All good...Thanks for rep added...
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Search for value in row. if found, copy column formulas into found column range
    By Groovicles in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-23-2017, 10:42 AM
  2. If cell says Not Found then give me details from another cell
    By Iain Garey in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-13-2014, 08:14 AM
  3. [SOLVED] Search within a column and repeat the search until all items are found
    By RANDY LIPOSKY in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-09-2014, 10:23 AM
  4. Search a column for a name and if found copy cell from the same row in a different column
    By Graham987 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-04-2013, 04:36 AM
  5. [SOLVED] How to find a cell value and when found give a value from other cell range.
    By tegno in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-02-2013, 04:09 PM
  6. give a value based on data found in a column - put need a value from it's row
    By hoolie in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-02-2009, 12:03 AM
  7. Macro to Search column and if found, copy a cell within the worksheet
    By SKooT1027 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-16-2008, 01:12 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1