Run Match like Vlookup

[DC]

Is there a function that will work like a vlookup, but instead of finding exact matches, it will find a cell that -contains- the lookup value?

 

[maxflia10]

There's Find under the Edit menu or Find (which is case sensitive) or Search functions you can try.

 

[Mark W.]

On 2002-10-17 16:56, DC wrote:
Is there a function that will work like a vlookup, but instead of finding exact matches, it will find a cell that -contains- the lookup value?

Do you need to know the cell reference of the matching value?

 

[DC]

I'd like to be able to run it like a vlookup where I can bring a cell that is to the match, but if I could get the cell # that the mathc was found that would also work.

 

[Juan Pablo González]

=MATCH(A1,B:B,0)

would return the row number of which A1 appears in column B. Is something like this what you're after ?

 

[Mark W.]

Perhaps...

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
1	4	$C$4	1
2			2
3			3
4			4
5			5
6
Sheet5

Juan, one of us is going to "hit on it" eventually.
This message was edited by Mark W. on 2002-10-17 17:56