I have a worksheet that has an alphabetical guest seat list with
corresponding table numbers. The goal is to pull the names from this
alphabetical list onto a different worksheet that breaks down the guests by
table number. I am having trouble with the IF formula (pending I am even
doing this correctly). If a false statement is returned, I need the formula
to search through the alphabetical list for the first true statement.