Find and return if is true
- Thread starter Daniel Valle
- Start date
Somendra Misra
Excel Ninja
Hi Daniel,
You have not explained the logic to get the values? and also upload a sample file not images.
Regards,
You have not explained the logic to get the values? and also upload a sample file not images.
Regards,
Daniel Valle
New Member
Thank you for be fast and sorry...
I'll want to find formula that find a text in a sentence if match and return a the word that I'm looking for is within, with 7 variables, if not find any of 7 variables, put False or "".
Example:
Sentence Text that I want with formula
3RD POINT CONNECTION, DETACHAB 3RD
RETRACTOR, STANDARD, R27, GM G RETRACTOR
LAP, PRETENSIONER, PLP1.5, LH, LAP
BUCKLE, HEAD, K12AT, 2G, SATUR BUCKLE
TUBE ASSY, RETRACTOR, R200, AS RETRACTOR
PILLAR LOOP, ASSY WITH HARDWAR PILLAR
ASSY, BUCKLE, SINGLE, BLT BKL BUCKLE
ANCHORPLATE, FORD V363 ANCHORPLATE
CHANNEL, ASSEMBLY, WITH WEB PR FALSE OR SPACE
Sorry My English is not my mother language...
Thank you and Regards
I'll want to find formula that find a text in a sentence if match and return a the word that I'm looking for is within, with 7 variables, if not find any of 7 variables, put False or "".
Example:
Sentence Text that I want with formula
3RD POINT CONNECTION, DETACHAB 3RD
RETRACTOR, STANDARD, R27, GM G RETRACTOR
LAP, PRETENSIONER, PLP1.5, LH, LAP
BUCKLE, HEAD, K12AT, 2G, SATUR BUCKLE
TUBE ASSY, RETRACTOR, R200, AS RETRACTOR
PILLAR LOOP, ASSY WITH HARDWAR PILLAR
ASSY, BUCKLE, SINGLE, BLT BKL BUCKLE
ANCHORPLATE, FORD V363 ANCHORPLATE
CHANNEL, ASSEMBLY, WITH WEB PR FALSE OR SPACE
Sorry My English is not my mother language...
Thank you and Regards
Daniel Valle
New Member
Sorry my previous post put the rows togheter...
Sentence Text that I want with a formula
3RD POINT CONNECTION, DETACHAB 3RD
RETRACTOR, STANDARD, R27, GM G RETRACTOR
LAP, PRETENSIONER, PLP1.5, LH, LAP
BUCKLE, HEAD, K12AT, 2G, SATUR BUCKLE
TUBE ASSY, RETRACTOR, R200, AS RETRACTOR
PILLAR LOOP, ASSY WITH HARDWAR PILLAR
ASSY, BUCKLE, SINGLE, BLT BKL BUCKLE
ANCHORPLATE, FORD V363 ANCHORPLATE
CHANNEL, ASSEMBLY, WITH WEB PR FALSE
Sentence Text that I want with a formula
3RD POINT CONNECTION, DETACHAB 3RD
RETRACTOR, STANDARD, R27, GM G RETRACTOR
LAP, PRETENSIONER, PLP1.5, LH, LAP
BUCKLE, HEAD, K12AT, 2G, SATUR BUCKLE
TUBE ASSY, RETRACTOR, R200, AS RETRACTOR
PILLAR LOOP, ASSY WITH HARDWAR PILLAR
ASSY, BUCKLE, SINGLE, BLT BKL BUCKLE
ANCHORPLATE, FORD V363 ANCHORPLATE
CHANNEL, ASSEMBLY, WITH WEB PR FALSE
Daniel Valle
New Member
Somendra Misra
Excel Ninja
@Daniel Valle
Consider your 7 words in C1:C7. Sentence in H1 and down, put below array formula in G1 and copy down:
=IFERROR(INDEX($C$1:$C$7,MATCH(1,--ISNUMBER(SEARCH($C$1:$C$7,H1)),0)),"")
Enter with Ctrl+Shift+Enter.
Regards,
Consider your 7 words in C1:C7. Sentence in H1 and down, put below array formula in G1 and copy down:
=IFERROR(INDEX($C$1:$C$7,MATCH(1,--ISNUMBER(SEARCH($C$1:$C$7,H1)),0)),"")
Enter with Ctrl+Shift+Enter.
Regards,
Daniel Valle
New Member
Thank you Somendra, Works perfect....
and please apologize for my mistakes in previous post.. I need a tutorial to use this
and please apologize for my mistakes in previous post.. I need a tutorial to use this
Somendra Misra
Excel Ninja
Alternatively you can also try below normal formula no CSE reqd.
=LOOKUP(9.9999E+307,SEARCH($C$1:$C$7,G1),$C$1:$C$7)
Regards,
=LOOKUP(9.9999E+307,SEARCH($C$1:$C$7,G1),$C$1:$C$7)
Regards,