Metaripley
Board Regular
- Joined
- Dec 31, 2014
- Messages
- 93
I want to use the search function but from a list.
Ive got a column with a string of text. (A)
And Ive got a column with a short string of text. (B)
And a column with a category corresponding with the short string. (C)
Now I want to use the list of short string to find the same in the long string list. (D)
List (B/C) contain more then 64 rows.
I used a consecutive If function but it cannot contain more then 64.
=IF(ISNUMBER(SEARCH(_18,P5)),_18.1,IF(ISNUMBER(SEARCH(_19,P5)),_19.1,IF(ISNUMBER(SEARCH(_20,P5)),_20.1,IF(ISNUMBER(SEARCH(_21,P5)),_21.1,IF(ISNUMBER(SEARCH(_22,P5)),_22.1,IF(ISNUMBER(SEARCH(_23,P5)),_23.1,IF(ISNUMBER(SEARCH(_24,P5)),_24.1,IF(ISNUMBER(SEARCH(_25,P5)),_25.1,IF(ISNUMBER(SEARCH(_26,P5)),_26.1,IF(ISNUMBER(SEARCH(_27,P5))
Can I combine a MATCH/SEARCH function in any way maybe?
<tbody>
</tbody>
Ive got a column with a string of text. (A)
And Ive got a column with a short string of text. (B)
And a column with a category corresponding with the short string. (C)
Now I want to use the list of short string to find the same in the long string list. (D)
List (B/C) contain more then 64 rows.
I used a consecutive If function but it cannot contain more then 64.
=IF(ISNUMBER(SEARCH(_18,P5)),_18.1,IF(ISNUMBER(SEARCH(_19,P5)),_19.1,IF(ISNUMBER(SEARCH(_20,P5)),_20.1,IF(ISNUMBER(SEARCH(_21,P5)),_21.1,IF(ISNUMBER(SEARCH(_22,P5)),_22.1,IF(ISNUMBER(SEARCH(_23,P5)),_23.1,IF(ISNUMBER(SEARCH(_24,P5)),_24.1,IF(ISNUMBER(SEARCH(_25,P5)),_25.1,IF(ISNUMBER(SEARCH(_26,P5)),_26.1,IF(ISNUMBER(SEARCH(_27,P5))
Can I combine a MATCH/SEARCH function in any way maybe?
A | B | C | D |
AUTOSHOP VAN DENHEUSDEN-ZO | Total | Car | Car |
APOTHEEK DEMEULEBERINGEN | Stockpaal | Home | |
BVBA T HOF BERINGEN | Park | Car | Dokter |
AMERIKAAMSE STOCPAAL | Auto | Car | Home |
DR. JOHAN VANDERLUMMEN | Hof | Dokter | Dokter |
TOTAL NB000629 TTESSENDERL | vanderlummen | Dokter | Car |
Q PARK ASTRIDPLEIN | Car | ||
P - DEN HAAG 48068 | |||
AUTOSHOP VAN DENHEUSDEN-ZO | Car |
<tbody>
</tbody>
Last edited: