If you want to enter a value in A1 and in B1 have the whole sentance
returned to you then the following formula entered into A1 should work

=INDEX(A2:F4,MATCH(A1,B2:B4),1)& " "
&VLOOKUP(INDEX(A2:B4,MATCH(A1,B2:B4),1),A2:F4,2 ,0) & " " &
VLOOKUP(INDEX(A2:B4,MATCH(A1,B2:B4),1),A2:F4,3,0) & " " &
VLOOKUP(INDEX(A2:B4,MATCH(A1,B2:B4),1),A2:F4,4,0) & " " &
TEXT(VLOOKUP(INDEX(A2:B4,MATCH(A1,B2:B4),1),A2:F4, 5,0), "dd/mm/yyyy") & " "
& VLOOKUP(INDEX(A2:B4,MATCH(A1,B2:B4),1),A2:F4,6,0)


Cheers
JulieD

"Samrasr" wrote in message
...
Below is an example of data in my excel sheet.
A B C D E F
Cell 1 ?
cell 2 Steve 1 to 10 13/2/04 britain
cell 3 Raj 11 to 17 15/2/04 india
cell 4 Ricky 18 to 35 14/2/04 Spain

Now if i enter a numerical value in A1 (where '?' is), i need a formula
which will check the column B and produce a result as desired below

Entery number = 9 then print "Steve 1 to 10 13/2/04 britain"
Entery number = 12 then print "Raj 11 to 17 15/2/04 india"
Entery number = 19 then print "Ricky 18 to 35 14/2/04 Spain"

Please explain in step by step process, and in detail, im really a novice.

Please help find me find the formula that solves this problem. thanks

Ricky Samras