For some rerason i have copied a column across and the Vlookup does not want to work on the cells. If i double click on the cell and press enter, the vlookup then works!!!??
Not sure why....but i have formatted all cells multiple times thinking this may be the issue.....any help appreciated.
Bookmarks