"Freddo" wrote:
=INDEX(Delivery Notes!$F$2:$F$500,MATCH(1,(F6=Delivery
Notes!$C$2:$C$500)*(O6=Delivery Notes!$E$2:$E$500),0))(one cell)

Try this corrected formula (lightly tested here ok),
array-entered as befo
=INDEX('Delivery Notes'!F2:$F$500,MATCH(1,(F6='Delivery
Notes'!$C$2:$C$500)*(O6='Delivery Notes'!$E$2:$E$500),0))

Think the culprit was the 2 missing apostrophes: ' just before and after the
sheetname ref in the formula. It's good practice to include these
apostrophes, irregardless whether there are spaces in the sheetname or not.

This is the formula in my formula bar
the curly brackets dont seem to have been pasted

Yes, that's ok. The curly braces are inserted by Excel (not to be typed in)
and won't be copied.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---