Hi, wondered if some one could help, I have a number of worksheets making up a rota / schedule of sorts, there are four locations, sheet for each and the fifth sheet relates to the users.

What I wnat to do is be able to allocate the users around the four sites and then the fifth sheet shows them where they should be at any particular day.

I done this to some extent but unfortunatley the IF statement only allows for seven if's in one statement, i.e.

=IF(S1!C10=A3,"Site 1",IF(S2!C10=A3,"Site 2",IF(S3!C10=A3,"Site 3",IF(S4!C10=A3,"Site 4",IF(S1!C12=A3,"Site 1,IF(S2!C12=A3,"Site 2........etc

Note each site has various rooms where an individual could be therefore I have to check each room C10, C12, C14, C16 at most locations to see if it equals the value held in A3 in the fifth sheet, where A3 etc would equal the users name.

As I say the above IF works but obviously I can't check all rooms, any body able to give me an example of how I could do it another way.

I have look at VLOOKUP etc but totally baffle by the examples as they don't seem to be applicable to my needs.

Thanks, Colin

[Edited by evanscolin on 17-03-2006 at 04:06 PM GMT]

Hello Evanscolin,

Would you be able to post your workbook as an attachment in here or perhaps e-mail it to me so that I can see exactly what you're trying to do?

____________________________
--John
www.FastLiveHelp.com