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.
