Search with multiple strings

		Microsoft Office Forums > Microsoft Excel > Excel
Search with multiple strings

03-02-2013, 02:53 PM

macropod

Windows 7 64bit Search with multiple strings

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,527

Try:
=OFFSET($A$2,MATCH(S11,$A$2:$A$7,0)-1,0)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
search on multiple word documents	Guy Roth	Word	7	03-06-2017 01:31 PM
Find, aka search aka ctrl+pgdn across multiple lines	snarfii	Word	1	04-22-2012 09:56 PM
Autotext strings are being stripped of their format when called from VBA	JEilerts	Word VBA	2	04-21-2012 07:49 AM
Removing Character Strings	digitalhecht	Word	2	10-17-2011 12:53 PM
update style of all strings available between two specific strings	vikrantkale	Word	1	03-28-2011 06:13 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:17 AM.