Offset

[jjdwhitfield]

All

I hope you can help

I have a fomula in Cell E27 that returns the last value in a column on another tab which is a percentage

=LOOKUP(9.99999999E+307,'SUMMARY MONTHLY STATS'!C6:C59)

In the cell next to it I want to return the character in the column next to it. I have tried the below but it is not working any ideas?

=OFFSET(LOOKUP(9.99999999E+307,'SUMMARY MONTHLY STATS'!C7:C59),,1)

Kind Regards

Jon Whitfield

 

[Domenic]

Try...

=OFFSET(INDEX('SUMMARY MONTHLY STATS'!C6:C59,MATCH(9.99999999999999E+307,'SUMMARY MONTHLY STATS'!C6:C59)),,1)

However, the following can be used instead...

=LOOKUP(9.99999999999999E+307,'SUMMARY MONTHLY STATS'!C6:C59,'SUMMARY MONTHLY STATS'!D6:D59)

Hope this helps!

 

[jjdwhitfield]

Thank you!!