hlookup to skip past first found 'lookup_value'

Given you're only looking to row 5 (hardwired) you could reduce the size of your array (from D10:DA50 to D10:DA14) which would give you a tiny performance gain...

anyway, you could use the following INDEX based approach - note this is an array formula and requires you use SHIFT + CTRL + ENTER to commit

note also assumption where $B$5 houses which instance you wish to return (1st, 2nd, 3rd etc..)

=INDEX(Arg!$D$10:$DA$50,5,SMALL(IF(Arg!$D$10:$DA$10=$B$4,COLUMN($D:$DA)-3),$B$5))

once array is set the formula will appear encased within {}

Hope that helps.

Thanks alot - I'm having a play around with your post -

I'll let you know how I get on.


Ben

Thanks DonkeyOte!

Your a genius never used an Array Fomula before I'm not 100% sure how this works yet but I'll get there!

I have managed to edit so I can return any result in the column but editing only works when I click on the = button, NOT when F2ing into it! I have to select the 2nd argument and change it manualy that way - bit strange but it works.


Thanks again for your help.


Regs


Ben