Look up diagonally?

[paralyzedcitizen]

Hi everyone,
I'm using HLOOKUP to lookup a value in a table. (below)

HLOOKUP('S_Victoria sections'!BV223,'7 fans'!I$11:BG$20,10)

It looks along row 11 looking for the right number and (eg 2, circled green) and grabs the right flow rate from row 20 (circled red). What I also need is a formula to look up the value to it's left (circled blue).

Any ideas?

[Ecniv]

The same formula that gives you the red circle, but add on an offset function. I think it can be used in normal excel -check the help on it.

[paralyzedcitizen]

Hmmm, it doesn't look like you can use an offset function with the Hlookup function as the hlookup function does not return a cell reference but instead a value. I tried placing the offset around the hlookup function but this did not work.

Am I right in thinking this wont work or am I writing it wrong?

[Siddharth Rout]

The picture attached should be self explanatory...

If you still have doubts, please ask

[paralyzedcitizen]

Thanks Koolsid, that's similar to what I want but not quite.
I have a table similar to the one below but larger. I'm looking up the reference number (1,2,3) and then looking up the the value of "Val a". So if I looked up reference 1 I would get 34.

Any ideas?