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

Could you copy the *actual* formula (copy it from the formula bar)
and paste in your response here ?

Check also that the sheetname: Delivery Notes
in the formula is correctly spelled and match exactly* what's on the tab
(look out for any extra "invisible" white spaces in either which
could throw the matching off)
*except for case

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