vlookup / Find

[Devaguru1986]

Hi All,

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

example:
[TABLE="width: 500"]
<tbody>[TR]
[TD]NAME (Column A)[/TD]
[TD]SHORT NAME (Column B)[/TD]
[TD]Result (Column C)[/TD]
[/TR]
[TR]
[TD]AIRTEL (SL) LIMITED[/TD]
[TD][TABLE="width: 81"]
<tbody>[TR]
[TD="class: xl65, width: 81"]COMMITTEE[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]#NA[/TD]
[/TR]
[TR]
[TD][TABLE="width: 389"]
<tbody>[TR]
[TD="class: xl65, width: 389"]GOAL[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 81"]
<tbody>[TR]
[TD="class: xl65, width: 81"]COUNCIL[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]#NA[/TD]
[/TR]
[TR]
[TD][TABLE="width: 389"]
<tbody>[TR]
[TD="class: xl65, width: 389"]INTERNATIONAL COMMITTEE OF.[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 81"]
<tbody>[TR]
[TD="class: xl65, width: 81"]FUND[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]COMMITTEE[/TD]
[/TR]
[TR]
[TD][TABLE="width: 389"]
<tbody>[TR]
[TD="class: xl65, width: 389"]COMMUNITY ANIMATION AND[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 81"]
<tbody>[TR]
[TD="class: xl65, width: 81"]LEONE[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]#NA[/TD]
[/TR]
[TR]
[TD][TABLE="width: 389"]
<tbody>[TR]
[TD="class: xl65, width: 389"]CARITAS - CRS FUNDS[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD]FUND[/TD]
[/TR]
[TR]
[TD][TABLE="width: 389"]
<tbody>[TR]
[TD="class: xl65, width: 389"]JEAN-PIERRE LEGENDRE[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD]#NA[/TD]
[/TR]
[TR]
[TD][TABLE="width: 389"]
<tbody>[TR]
[TD="class: xl65, width: 389"]BRITISH HIGH COMMISSION[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD]#NA[/TD]
[/TR]
[TR]
[TD][TABLE="width: 389"]
<tbody>[TR]
[TD="class: xl65, width: 389"]THE SAVE THE CHILDREN FUND[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD]FUND[/TD]
[/TR]
[TR]
[TD][TABLE="width: 389"]
<tbody>[TR]
[TD="class: xl65, width: 389"]DFID -OFFICE ACCOUNT[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD]#NA[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


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