chrislowe2006
New Member
- Joined
- Feb 13, 2014
- Messages
- 8
Hi,
I am creating a spreadsheet in which I need to have the user basically book seats and have excel update those results on another sheet within the workbook. On Sheet 1 I have the list of destinations they chose from and the seat class they would like. On sheet two I have a tracker which needs to update to occupied once a seat is booked and return the seat number back on sheet one. If a seat is already occupied I would like it to test the next cell and so on. If no seats are free in that class it would return a message saying "none available."
Here is my current attempt. But I would like to know if A, it is possible and B, is there a way to shorten the code as there are multiple destination combinations and differing class options with a large number of seats available.
IF(AND(A1="London",A2="Manchester",A3="First"), IF(Sheet2!A1="Vacant","Occupied", [This is where I'am stuck as all I can figure out is to rewrite another if statement]
Thanks!
I am creating a spreadsheet in which I need to have the user basically book seats and have excel update those results on another sheet within the workbook. On Sheet 1 I have the list of destinations they chose from and the seat class they would like. On sheet two I have a tracker which needs to update to occupied once a seat is booked and return the seat number back on sheet one. If a seat is already occupied I would like it to test the next cell and so on. If no seats are free in that class it would return a message saying "none available."
Here is my current attempt. But I would like to know if A, it is possible and B, is there a way to shorten the code as there are multiple destination combinations and differing class options with a large number of seats available.
IF(AND(A1="London",A2="Manchester",A3="First"), IF(Sheet2!A1="Vacant","Occupied", [This is where I'am stuck as all I can figure out is to rewrite another if statement]
Thanks!