Help with a formula reference

[Cruiser69]

Hi all.

Is there a way to amend the formula below so that it references column B and not B2 when pasting Into any cell in column B.

=IFERROR(INDEX(Sheet3!$D$2:$D$4000,MATCH(B2,Sheet3!$A$2:$A$4000,0),1),"")


Thanks for looking.


Graham

 

[Cruiser69]

Sorry, I should have said pasting into any cell in Column L