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 ?
Bookmarks