Problem with a small lookup database ..... ???

[Rokku]

Hi

i have a list with ranges and i need to put it in one whole list ...

Ex --- this is what i have ....
Cell A1 = Name ex Mr Smith
Cell B1 = Start Range ex 10
Cell C1 = Stop RANGE ex 15
Cell D1 = Date 01/10/05

Cell A2 = Name ex Mr Black
Cell B2 = Start Range ex 18
Cell C2 = Stop RANGE ex 21
Cell D2 = Date 01/11/05
and so on.

What i need is this ..
i have a list of ranges ex from 1 to 100 under each other and in the
coloumns near them i will get the info ...

So i will get like so ..
Range
11 - Mr Smith - 01/10/05
12 - Mr Smith - 01/10/05
13 - Mr Smith - 01/10/05 ...
&
17 -
18 - Mr Black - 01/11/05
19 - Mr Black - 01/11/05
20 - Mr Black - 01/11/05....


what formulas should i use please ???

[[email protected]]

Hi Rokku,

I am not sure to fully understand ... but, for instance
=MID(A1,FIND("ex",A1,1)+2,LEN(A1)-FIND("ex",A1,1)+3)
is a formula that would extract Mr Smith from the cell A1 ...

HTH
Cheers
Carim