Hi would like some assistance please.
On sheet 1 I have prepared a list of passenger names with seats numbers in the following column each in individual cells eg 1A, 6B etc
EG column 1 passenger name - B SMITH, column 2 seat No - 12A
On sheet 2 I have a seat map with rows 1A 1B 1C 1D etc through to row 19A B C D each seat number in a seperate cell.
What I would like to do is have the cell on sheet 2 reflect the number 1 if the seat is occupied and if the seat is empty then the cell on sheet 2 would be empty too.
So in the above example sheet 2 would have the number 1 in the cell on sheet 2 which represents 12A, all othwr cells would be empty.
Hope this makes sense. Thanks in anticipation. Debb