« Looking up data in tables II | Main | Looking up Data in Tables IV »
September 15, 2004
Looking up Data in Tables III
For a 2d table lookup, we have to put VLOOKUP aside and use the OFFSET function in conjunction with MATCH as illustrated in the example below.Basically, each MATCH function is responsible for determining the correct row/column respectively of the table.
In the lookup table, we list major network affiliates for a set of major cities.
On another sheet, we see how the correct affiliate can be determined - given the correct pair of keys...
Posted by Dave at September 15, 2004 05:07 AM