Thanks for your help I have tried to make the range the same but it stills
come up with #NAME?

"Max" wrote:

(Or, perhaps it should be amended the other way round ..)

The above means perhaps change the 2 ranges within the MATCH part to:
Delivery Notes!$C$1:$C$500
Delivery Notes!$E$1:$E$500
(to be consistent with .. INDEX(Delivery Notes!$F$1:$F$500,..)

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---