Printable View
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?
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.
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?
The picture attached should be self explanatory...
If you still have doubts, please ask :)
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?