index match- with & not working (Format issue?)

[bloodybrit90]

Hey guys,

I am using the following formula.

=INDEX($I$4:$I$85,MATCH(B881&" "&C881,$H$4:$H$79,0))

Column B Part of the name: Mattamy-
Column C second part of the name: James place
Column H has the entire name (first and last)

The index worked for some, but not for all of the names. When I combine the two parts of the name and copy/ (Paste value) in the appropriate name in column H the formula works. Is this a formatting issue? Both cells are formatted as general.

Any help would be great.

 

[Aladin Akyurek]

Hey guys,

I am using the following formula.

=INDEX($I$4:$I$85,MATCH(B881&" "&C881,$H$4:$H$79,0))

Column B Part of the name: Mattamy-
Column C second part of the name: James place
Column H has the entire name (first and last)

The index worked for some, but not for all of the names. When I combine the two parts of the name and copy/ (Paste value) in the appropriate name in column H the formula works. Is this a formatting issue? Both cells are formatted as general.

Any help would be great.

Does...

=INDEX($I$4:$I$85,MATCH(B881&"*"&C881,$H$4:$H$85,0))

help?

 

[bloodybrit90]

Yes that worked. Does the * mean any value? If so can I string *** together?

 

[Aladin Akyurek]

Yes that worked. Does the * mean any value? If so can I string *** together?

A star as wildcard stands for a string of any length (0 to N).
If you want any string of length 3, try ??? for a ? means a single char.