Help required in lookup formula

[josephscott]

Hi,

I am using the following formula to try and find a value on another worksheet:

=(VLOOKUP($A11,'Actuals Raw'!$C$1:$AQ$195,MATCH(C$2,'Actuals Raw'!$C$1:$AQ$1,0),0))

This formula works fine, and it finds the correct row and column every time. The trouble is, I am looking to find the value "one to the right" of the value it finds. I have tried using the OFFSET function, but cannot seem to incorporate it into this formula. Any help appreciated.

 

[jasonb75]

Welcome to the board!

The simple solution would be

=VLOOKUP($A11,'Actuals Raw'!$C$1:$AQ$195,MATCH(C$2,'Actuals Raw'!$C$1:$AQ$1,0)+1,0)

 

[josephscott]

Jason,

Thank you very much for the swift and accurate reply. I spent a long time playing with this- if only I knew it was that simple.

Joe