Search results for query: *

All of the tables are actually on the same sheet so they can be displayed for spectators and participants. It is a set of competition brackets. I broke it down into a few steps and got it to work. Jenna

Countif wouldn't work because it is possible for a participants ID # to be there the same amount of times as someone else who made it to a further round (finals and consultation). I gave in, built a separate table where the participant ID is in column 1 and round eliminated in column 2. The ID...

Not to mention the fact that if I combine the data, the same data (participant number) will be replicated in the table for each round the particiapnts qualifies for. It will be challenging to have Excel determine which round to return in a lookup. Jenna

Yes, I know how to do this in a single tables. Its not a horrible design, it is the design of the event. For this instance, tables get smaller and participants (and their data) get eliminated after each round and hence a new table with just the needed data. I am trying to avoid building...

Hi all, I found some questions close to this, but nothing exact. I have a value that I want to lookup in a table and return an adjacent value (vlookup) but if the value is not found in that table, look in another table, and if not found in that table, look in another. I have five tables I...