vlookup / Find

[Devaguru1986]

Hi All,

I need to do search a keyword in master column by vlookup,

example:

NAME (Column A)	SHORT NAME (Column B)	Result (Column C)
AIRTEL (SL) LIMITED	COMMITTEE <tbody> </tbody>	#NA
GOAL <tbody> </tbody>	COUNCIL <tbody> </tbody>	#NA
INTERNATIONAL COMMITTEE OF. <tbody> </tbody>	FUND <tbody> </tbody>	COMMITTEE
COMMUNITY ANIMATION AND <tbody> </tbody>	LEONE <tbody> </tbody>	#NA
CARITAS - CRS FUNDS <tbody> </tbody>		FUND
JEAN-PIERRE LEGENDRE <tbody> </tbody>		#NA
BRITISH HIGH COMMISSION <tbody> </tbody>		#NA
THE SAVE THE CHILDREN FUND <tbody> </tbody>		FUND
DFID -OFFICE ACCOUNT <tbody> </tbody>		#NA

<tbody>
</tbody>

I need to vlookup / find column B against Column A and the result to be displayed in column C.

 

[Marcelo Branco]

Welcome to Mr Excel

Maybe

Formula in C2 copied down
=LOOKUP(9.99E+307,SEARCH($B$2:$B$5,A2),$B$2:$B$5)

Hope this helps

M.

 

[Devaguru1986]

Welcome to Mr Excel

Maybe

Formula in C2 copied down
=LOOKUP(9.99E+307,SEARCH($B$2:$B$5,A2),$B$2:$B$5)

Hope this helps

M.

Works perfectly..thanks bro