look up doest not work

[hellosajjad]

I want to search "DC200807 00333 02" from list in Column "B" and then tell me figure in same row of Column F. what formula ca i use, lookup and match does not work becouse "DC200807 00333 02" this contain text & number both.

 

[WinteE]

What do you mean with "... this contain text & number both", is it a combination of contents of different cells ?

 

[Aladin Akyurek]

I want to search "DC200807 00333 02" from list in Column "B" and then tell me figure in same row of Column F. what formula ca i use, lookup and match does not work becouse "DC200807 00333 02" this contain text & number both.

X2: DC200807 00333 02

If columns B and F are sorted in ascending order on B...

=IF(LOOKUP(X2,$B$2:$B$1000)=X2,LOOKUP(X2,$B$2:$B$1000,$F$2:$F$1000),"Not Found")

Otherwise:

=INDEX($F$2:$F$1000,MATCH(X2,$B$2:$B$1000,0))

Adjust the ranges to suit.