double lookup

**Damedron** · 03-27-2009, 01:13 PM

I have a file that I would like to lookup variable row and a variable column. I have tired vlookup and hlookup but these do not work because you have to specify a given column or row versus having that column or row be variable. Is there a way to do this.

Think of a set of times tables. I would like to input 8 and 9 and get 72 as an output. How could I go about doing this?

Or in the attached file, I would like to say A and 15 and get A15.

**NBVC** · 03-27-2009, 01:16 PM

Try:

=INDEX($B$2:$J$16,MATCH(15,$A$2:$A$16,0),MATCH("A",$B$1:$J$1,0))

replace the 15 and "A" with cell references containing those inputs, if desired.

**Jorozco** · 03-27-2009, 03:29 PM

You can also try "Offset". Say you have the column # in cell A1, and row # in cell A2. Your table is in the range "B4:G20". Then your formula in cell C1 would look something like:

Please Login or Register  to view this content.

Notice that offset is "0-based". So (0,0) would be B4. If you want it "1-based", you can write the formula using "A3" instead of "B4". Hope this helps.

J.