Formula help needed

[sianh]

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I have another question I would like some help with if possible.<o></o>
<o> </o>
On sheet1 I have data showing a role in column A, day of the week column B and then along row 1 I have a number, 1 2 or 3. From C2:F85 I have the data that is needed. Basically this data shows who should be where, when.<o></o>
<o> </o>
Sheet2 is for the user to fill in. I have the days of the week down column A and along row 11 it shows merged cells (three cells) into which a user will enter a type, and beneath these merged cells are the numbers 1,2 and 3.<o></o>
<o> </o>
What I would like is for the user to select the role and then the data to be filled in by a formula. I can get it to show on the number and day of the week using index and match but I am confused about the three criteria – can anyone shed any light?<o></o>
Thanks<o></o>
Sianh<o></o>

 

[Dazzawm]

Can you post an example? Using excel jeanie or a program like that?

 

[sianh]

Sorry, I dont think I can - work computers dont let us do much!
Can you let me know which bit doesnt make sense so I can try and make it clearer?
Thanks

 

[pgc01]

Sorry, I dont think I can - work computers dont let us do much!
Can you let me know which bit doesnt make sense so I can try and make it clearer?
Thanks

Hi

Set this option in the board:

In the User CP
Settings & options->Edit Options->Miscellaneous Options

In the Message Editor Interface, enable:
Enhanced Interface - Full WYSIWYG Editing

This allows you to copy a table from excel directly to your post window.

It will help readability if you add some borders to the data you post.