Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help! Formula needed.
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 -- Ricky Samras |
#2
|
|||
|
|||
If you really mean "print", You'll need a macro - is that what you want?
If you mean to put (for an entry in A1 of 9) Steve 1 to 10 13/2/04 britain into six cells across in a row, then enter this in the leftmost cell: =INDEX(A$1:A$4,MATCH($A$1,$B$1:$B$4,TRUE)) then drag the fill handle (lower right corner of the cell) across five cells to the right. In article , "Samrasr" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula needed | Excel Worksheet Functions | |||
Formula needed | Excel Worksheet Functions | |||
Look Up and Cell Reference - Formula Help Needed | Excel Worksheet Functions | |||
Formula needed | Excel Worksheet Functions | |||
Complex formula help needed | Excel Worksheet Functions |