Formula needed.

[baggarwal]

Hi All:

A2 is a column that contains a cost center RMZ00. The range B2 to C6. Contains RMZ00 and a value to the right of it.

In A3, I need a formula that will lookup A2 in range B2:C6 and return the value in column C where the match to column B is found.

Can someone please tell me how this can be done.

 

[kskinne]

=VLOOKUP($A$2,$B$2:$C$6,2,FALSE)

should do the trick

kevin

 

[baggarwal]

So Sorry:

The lookup value is RMZ00 General, I want to lookup the first five digits in the range defined by B:C. I tried the following formula and it didn't work.

=Vlookup((Left(A2,5),B2:C6,2,False)))

 

[kskinne]

EDITED:

nevermind, use this formula:

=VLOOKUP(LEFT(A2,5),B2:C6,2,FALSE)

otherwise if this doesn't work for you, could you please post a sample of your data?

thanks
kevin

 

[baggarwal]

This didn't work.

The Lookup value is RMZ00 General, this is in Cell A2. B2:C6 contains RMZ00 56. I want to find RMZ00 not RMZ00 General in the range B2:C6 and have it return 56.

 

[Juan Pablo González]

And this...

=VLOOKUP(LEFT(A2,5),B2:C6,2,FALSE)

 

[kskinne]

see my edited post above, i think you were on the right track, your syntax was just wrong

hth
kevin

 

[Andrew Poulsom]

This:

=VLOOKUP(LEFT(A2,5),B2:C6,2,FALSE)

worked for me.

 

[Aladin Akyurek]

=VLOOKUP(LEFT(A2,5)&"*",$B$2:$C$6,2,0)

or even...

=VLOOKUP("*"&LEFT(A2,5)&"*",$B$2:$C$6,2,0)

if the lookup value is part of a value in B.