In Cell E8 (Which has been named as 'Operator) I have entered the following formula

VLOOKUP(Direct,C:\My Documents\[Proct excel set up.xls]\Sheet1!\Operators,0,1)

My Table is on another workbook called 'Proct excel set up'

The Table range is called 'Operators'

The first cell in my table range has the word 'Direct' in the cell

In data validation, I have set this up for List and in the source I have put the named range of my cell E8....operator

and I simply cant get the formula to work, can anyone see my obvious mistake ???