a simple question....about string searching

[deadfish]

Hi,
I have a worksheet like this:

a 1
bx 2
cax 3

I would like to search the cell which just match the first character.
For example, I would like to search the cell start with "b" should
return "2" for me....

How to write the formula to acheive this?

Thanks!

 

[ivano]

Tty:

=VLOOKUP("b",LEFT($A$1:$B$3,1),2,FALSE)
array formula.

 

[Aladin Akyurek]

=VLOOKUP("b"&"*",$A$2:$B$4,2,0)

or

=VLOOKUP(D2&"*",$A$2:$B$4,2,0)

where D2 houses a partial lookup string like "b" (without double quotes).

 

[deadfish]

Thanks!

But is it possible to use the MATCH function

 

[Domenic]

Hi,

try,

=INDEX(B1:B3,MATCH("b"&"*",$A$1:$A$3,0))

Hope this helps!

 

[Aladin Akyurek]

Thanks!

You're welcome.

But is it possible to use the MATCH function?

Just curious: Any specific reason for MATCH?

 

[Peo Sjoblom]

Home work?

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom