Using INDEX rather than OFFSET to return value relative to LOOKUP result

[Yamezz]

I have the following formula to get the latest value in column I when column G = the value in F27 and column H = the value in P2

=LOOKUP(2,1/((Analysis!$G:$G=$F27)*(Analysis!$H:$H=$P$2)),Analysis!$I:$I)

I now need to get the value in the cell two columns to the right of this value. I've read that using INDEX rather than OFFSET will prevent the huge slowdown in Excel with the volatile nature of OFFSET, but I'm at a loss to work out how to achieve the result I'm after. Any suggestions?

 

[Fluff]

If you mean you want the value from col K you can use

=LOOKUP(2,1/((Analysis!$G:$G=$F27)*(Analysis!$H:$H=$P$2)),Analysis!$K:$K)

although it's best to avoid using whole column references, as it can slow the workbook down.

 

[Yamezz]

Thanks Fluff. That's what happens when I find bits of code on the internet and deploy it without actually understanding what it's doing. Your solution is immediately obvious in hindsight, but I needed you to point it out!
I'll take your advice with the whole column references too. Cheers.

 

[Fluff]

You're welcome & thanks for the feedback.