Sorry, not too good with Excel, but what I am trying to achieve is this vlookup located in sheet1 cell R7:
Which displays a room number, e.g.
However, if the room already exists in the column, I want it to find another value in the VLOOKUP that doesn't already exist in the column.
I check if it exists in the column by using (located in sheet1 cell R8):
So if this query is FALSE, then it's ok to use the VLOOKUP above, but if it returns TRUE it should keep searching until it finds one that is FALSE.
Hope this makes sense