Hi EveryB

I need to compare a list of datas.

I have got 4 colomns of data as described below

server1-filesize server1-filename server2-filesize server2-filename

I want to compare the the filenames and its size present in the server 1 with the files in the server2. and want to list down the files seperately.

Thanks in Advance,
Arun

How i think i would do this is to use the VLOOKUP Function,
Create a new file with the list of files and sizes from Server1 on a new sheet

then as long as everything in the 2 names are identical then use VLOOKUP to lookup the list in server2

Hope that makes sense
Dave