Quote Originally Posted by newdoverman View Post
This is a bit late but you might want to consider it.
Enter this in ES4
Formula: copy to clipboard 
=IFERROR("H"&INDEX(YR3:ABS3,MATCH(TRUE,YR3:ABS3<>"",0)),"A"&INDEX(ABT3:AEU3,MATCH(TRUE,ABT3:AEU3<>"",0)))

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
This works great BUT it needs to know what the first number found is. So if for example if there is '3' in cell YZ3 but there is a '5' in ABU3 then cell ES4 should return 'A5'. This is because the first instance of data was found in the 'A' range and the actual number found was '5'.

I've had to re-open this as I've been trying to use Beamersnw's code in a macro but since it's more than 255 characters it's having trouble running it so I need a solution that is 255 characters or less!