Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by jennag
-
conditional statement with multiple Vlookups
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- jennag
- Post #11
- Forum: Microsoft: Office
-
conditional statement with multiple Vlookups
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...- jennag
- Post #8
- Forum: Microsoft: Office
-
conditional statement with multiple Vlookups
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- jennag
- Post #4
- Forum: Microsoft: Office
-
conditional statement with multiple Vlookups
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...- jennag
- Post #3
- Forum: Microsoft: Office
-
conditional statement with multiple Vlookups
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...- jennag
- Thread
- Replies: 11
- Forum: Microsoft: Office
