lookup taking only part of result

R

racer25

Hi Guys

I have a problem, I am trying to do some sort of a lookup on a range o
cells and when Excel finds a match to take a mid string approach to th
data it finds.

Example 1

RM3c.Racer
This Player is on our complaint list.
Rank: 3-Star General ( 16 )

Assuming this data is in cells A1:A3 I want a formula to extract onl
the 3 Star General i.e. search for Rank then MID(Text,7,30) 7 in 3
characters long,

Example 2

RM3c.Racer
Rank: 3-Star General ( 16 )

The rank line is now on A2 here lies my problem, I have to do this fo
50 plus ppl.

Your help and guidance would be appreciated.

Ro

Attachment filename: example.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=64677
 
R

racer25

Maybe I did this wrong but this doesn't search a rabge of cells, Irank
could be in A2 or A3

Thanks for quick response,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup Mid$ 2
Help with VLookup 2
Vlookup function 4
How to stop a general format cell 1
VBA Custom function for lookup 9
Excel Count Problem 1
Match and lookup data 2
Countif Cell Contains A Portion Of Text 2

Top