Hi Everyone :-)
I have a below formula which extracts the v and number attached to it I would like to copy this across all columns and change row for each column.
So for example 1st column reference will be B4, the second column would have a reference B5 and so on, it's probably worth to mention that cells I am referencing to are in other sheet hence why there's Ref! before B4 is this why absolute column and relative row not working??
Formula: copy to clipboard 
=MID(Ref!$B4,IFERROR(SEARCH(" v? ",Ref!$B4,1),SEARCH(" v?? ",Ref!$B4,1))+1,3)


Thanks
Dan