MS Excel: VLOOKUP Function (WS) - TechOnTheNet.com
Question: I want to do a VLOOKUP if a statement is true. Example: If cell A2 = cell F9, I want to do a virtual lookup depending on what is in cell E34, the function would return corresponding data from cells defined as "TEAM". This is what I came up with:...