+ Reply to Thread
Results 1 to 4 of 4

Search, find and then return row to use in chart.

  1. 06-16-2014, 07:44 PM #1
    aloconnor
    aloconnor is offline
    Registered User
    Join Date
    10-15-2012
    Location
    Aberdeen, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    22

    Search, find and then return row to use in chart.

    I have attached an example sheet with my problem. Any help will be most appreciated.

    Thanks
    Ali
    Search, find and return rows.xls
    Reply With QuoteRegister To Reply
  2. 06-16-2014, 07:52 PM #2
    lexusap
    lexusap is offline
    Forum Contributor
    Join Date
    08-16-2012
    Location
    Sydney
    MS-Off Ver
    Excel 2019
    Posts
    209

    Re: Search, find and then return row to use in chart.

    Hi,

    The answer would be - the normal Vlookup would do the job perfectly. Attached copy of workbook for your reference.

    Thanks
    Lex
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 06-16-2014, 07:57 PM #3
    aloconnor
    aloconnor is offline
    Registered User
    Join Date
    10-15-2012
    Location
    Aberdeen, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    22

    Re: Search, find and then return row to use in chart.

    Many thanks. I feel like an idiot for not thinking of that myself now!!!!

    Thanks
    Ali
    Reply With QuoteRegister To Reply
  4. 06-16-2014, 08:18 PM #4
    lexusap
    lexusap is offline
    Forum Contributor
    Join Date
    08-16-2012
    Location
    Sydney
    MS-Off Ver
    Excel 2019
    Posts
    209

    Re: Search, find and then return row to use in chart.

    no worries Glad to help
    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 numbers in a text string, find largest "value" return a value
    By OilGasKing in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-27-2013, 09:01 PM
  2. [SOLVED] Search a column to return values just above and below the search criteria
    By Rehpot in forum Excel General
    Replies: 4
    Last Post: 12-21-2012, 10:35 AM
  3. Search...Return...give info based on the return address
    By deek1004 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-11-2012, 03:36 PM
  4. [SOLVED] Excel 2007 : need help to search a column, find a letter, and return the number at the top of the row
    By Roadhogg71 in forum Excel General
    Replies: 8
    Last Post: 04-11-2012, 04:03 PM
  5. find name; search column; if date found-return 3 data pts; move to next row
    By cdl in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-28-2008, 10:43 AM

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