hlookup to skip past first found 'lookup_value'

Hi there,

I'm using the following formula "=HLOOKUP($B$4,Arg!$D$10:$DA$50,5,FALSE)"

With Cell $B$4 as the 'Lookup_value' I wish to pull the second instance of the 'lookup_vlaue' not the first from within the 'Table_Array'

Is there a way to do this?

Later on I'd like to skip to the 3rd column/instance etc.

It's not practical for me to change the size of the 'Table_array'

Thanks for any sugestions.

Regards,


Ben