Using FIND formula with 3 FIND?

marreco

marreco

Well-known Member
Joined
Jan 1, 2011
Messages
609
Office Version
  1. 2010
Platform
  1. Windows
hI.
I can use this separate function, you could use them together?

Code: 
=IF(ISERROR(FIND($S$1,J9));$R$1;IF(ISERROR(FIND($S$2,J9));$R$2;IF(ISERROR(FIND($S$3,J9));$R$3;"Not Find)))

Thank you!!!
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
Sort by date Sort by votes
Try if this work:
=INDEX($R$1:$R$3,MATCH("*"&J9&"*",$S$1:$S$3,0))
or if there is no match at all
=IFERROR(INDEX($R$1:$R$3,MATCH("*"&J9&"*",$S$1:$S$3,0)),"")
(07/10/13 Excel version)
 
Upvote 0
marreco said:
hI.
I can use this separate function, you could use them together?

Code: 
=IF(ISERROR(FIND($S$1,J9));$R$1;IF(ISERROR(FIND($S$2,J9));$R$2;IF(ISERROR(FIND($S$3,J9));$R$3;"Not Find)))

Thank you!!!
Click to expand...

FIND is case-sensitive. If this is not what you want, switch to SEARCH...

=LOOKUP(9.99999999999999E+307,FIND($S$1:$S$3,J9),$R$1:$R$3)

For a Index/Match approach, see Robert's reply.
 
Upvote 0
Hi.

Both form of response helpful, thank you very much!
 
Upvote 0
You must log in or register to reply here.

Similar threads

MrDB4Excel
  • Solved
DuckDuckGo Conditional Format
2
Replies
12
Views
289
MrDB4Excel
MrDB4Excel
N
  • Question
VBA - Help Making Alteration to Code
Replies
6
Views
280
Nordicrx8
N
gtd526
  • Question
macro to add correct number of ")" at end of nested IF statement
Replies
1
Views
128
gtd526
gtd526
T
  • Solved
Split first word only if it is part of a range.
2
Replies
15
Views
364
mumps
mumps
D
  • Question
Find matching value in table, check if specific cell in same row is empty, find next if not
Replies
0
Views
207
dubyarly
D

Forum statistics

Threads
1,215,063
Messages
6,122,935
Members
449,094
Latest member
teemeren

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top