« Looking up Data in Tables III | Main | Text Formulas: Extracting First & Last Names »
September 16, 2004
Looking up Data in Tables IV
VLOOKUPis useful as long as we are looking on the right side of the table. There is however a way to circumvent this restriction - as is illustrated in the example below.We actually have set aside VLOOKUP and use a combination of OFFSET and MATCH instead.
The MATCH function lets us know what row we are interested in, and then the OFFSET puts us in the correct column.
Posted by Dave at September 16, 2004 05:54 AM