vlookup won't look up.

[ajm]

i am looking up suppliers in another workbook that contains the category/sub category in which they sit. both files sit in the same folder on the network. all data is in text format. I am getting N/As where i should be getting results. everytime i change a cell, or try to Refresh, it kicks off the file open input box. Even if i start to click ok and remap the links, the pop up won't go away and the lookup values don't refresh.


what can be done to correct this?

 

[ajm]

have used XLookup and all is good again.