Results 1 to 6 of 6

Search for text and return values

Threaded View

Ninja2k Search for text and return... 09-28-2013, 03:42 PM
L-Drr Re: Search for text and... 09-29-2013, 09:07 AM
Ninja2k Re: Search for text and... 09-29-2013, 09:30 AM
hemesh Re: Search for text and... 09-29-2013, 09:22 AM
Ninja2k Re: Search for text and... 09-29-2013, 09:33 AM
hemesh Re: Search for text and... 09-29-2013, 02:22 PM
  1. #1
    Registered User
    Join Date
    01-24-2013
    Location
    Ireland
    MS-Off Ver
    Office 2010
    Posts
    34

    Search for text and return values

    I have two sheets in my workbook, Main Specs is where I have a list of specifications, I need to tidy them into my sheet named specs.

    I need a formula to do something like this:

    Using the Text in G4 to V4, I want to search main specs for that text and return the value from column B

    I want to put the values into g6, H6 etc

    I need the the first set of values to go on row 6 the second on row 7 etc


    E.g.

    Search for Product Description in the sheet Main Specs
    Finds Product Description at 'Main Specs'!A2
    Return Value Toshiba Satellite Pro L830-17T - 13.3" - Core i3 3227U - Windows 8 64-bit - 2 GB RAM - 500 GB HDD
    Put value at G6


    Can this be done wit ha formula?
    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. Replies: 4
    Last Post: 12-21-2012, 10:35 AM
  2. Replies: 3
    Last Post: 10-03-2012, 03:09 AM
  3. Search text file and return values
    By skyblues in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-27-2011, 11:44 AM
  4. Search text string for range of text values - return match
    By crugg in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-03-2010, 09:55 AM
  5. macro to search text & return values
    By leni in forum Excel General
    Replies: 11
    Last Post: 01-10-2009, 04:38 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1