Hlookup is a horizontal reference and you're table array argument is using a vertical reference. Try changing the All!G:T part of your equation to something like this All!10:40.