|In this forum, we don't usually answer homework questions directly, since the object is for you to figure how to use Excel to complete the assignment. |
With that spirit in mind, I'll offer a process for finding a solution. If you can't figure it out, come on back and we'll see if we can give you some more hints.
I am assuming that you have 2 tables, which I'll call Games and Games2. You want to look up the value in A14, first in Games and then in Games2. If it is not found in either table, return "". If it is found, then return the value from Column 2 of the first table it is found in.
You've got a good start with your single table lookup formula.
What I would try for the 2 table lookup is to start by entering the first IF, as above and then deciding what I want to do if the first IF (the ISNA(Games)) is TRUE. I don't want a "" yet because I haven't checked Games2. So I would then check Games2 for an ISNA and then return "" since both ISNA's would be TRUE if the value wasn't found in either table.
If the Games ISNA was TRUE, but the Games2 ISNA was FALSE, then the value must have been found in Games2, so next I'd do a VLOOKUP on Games2.
If both ISNA's were FALSE, the value must be in Games, so I'd finish up with a VLOOKUP on Games.
It's sort of an "first-second-second-first" logic path.