IF statements and updating other sheets

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!
 
Last edited:

Forum statistics

Threads
1,086,235
Messages
5,388,624
Members
402,127
Latest member
Jemx

Some videos you may like

This Week's Hot Topics

Top