+ Reply to Thread
Results 1 to 2 of 2

having trouble finding and showing cell value

  1. #1
    Registered User
    Join Date
    08-10-2012
    Location
    romania
    MS-Off Ver
    Excel 2007
    Posts
    1

    Angry having trouble finding and showing cell value

    hello

    i'm having trouble finding and returng the value of a cell in row that has the word "hdd" in it's value

    i have the next table :

    A | B | c | D | E | F |
    1.1 | hdd | 250 GB | 7200 RPM | Sata 2 | |
    2.2 | hdd | ssd | 500 GB | 5400 RMP | Sata2 |
    3.3 | hdd | 5400 RPM | sata 2 | 500 GB |
    and so on for 1000 rows

    In the next sheet i have :

    A | B | C | D | E |
    Product number | Category | Capacity | Speed | Interface |
    1
    2
    3

    I want in the second sheet to organaze the date to it's coresponding column, so i tried to use a search function but with no succes.

    in C1 : =IF([*search row of cell containing "gb"]ISNUMBER(SEARCH("gb";B1:F1));(*show the value of the cell containg "gb")B1:F1;(*else)"none")
    in D1 : search for "RPM" and do as above
    in E1 : Search for "sata" and do as above

    what formula should i use to get the table to look right ?

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux - O365
    Posts
    12,518

    Re: having trouble finding and showing cell value

    Hi

    as your second sheet seems to be the same as the first but with headers, copy paste to sheet 2 leaving an empty row and add headers
    I'm a newbie with PQ, so if my solution can be improved, please let me know. Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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