Formula help please

S

Samrasr

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
 
B

Bob Phillips

Very simply

=IF(A1=9,A2&" "&B2&" "&C2&" "&D2&" "&TEXT(E2,"dd/m/yy")&" "&F2,IF(A1=12,A3&"
"&B3&" "&C3&" "&D3&" "&TEXT(E3,"dd/m/yy")&" "&F3,IF(A1=19,A4&" "&B4&" "&C4&"
"&D4&" "&TEXT(E4,"dd/m/yy")&" "&F4,"")))

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

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

Top