Hi everyone!
Dunno if this is a quick question or not!
In excel, i would like to have a cell look up to see if a file exists on a harddrive.
For instance.
the cell will either say OK or not done.
OK would be if it can find the file on the harddrive i.e an excel file containing serial numbers of a particular computer brand. So the different cell headings above would be IBM, ACER, etc. the cell below these would then search for a file containing acer or ibm and if it finds it it will then put either OK or Not Done if not found.
I would want it to search for the name of the file that is in another cell or has part of the filename with in it.
Any advise would be greatly appreciated.
Cheers
Joel
Bookmarks