Combining sheets

[sfoust]

I am attempting to combine two excel documents each of which have some data I do and some data I do not need. Each have user names listed, and document A has all of the users on document B, but also additional users. I have two questions.

a) Would it be possible to somehow match information to the user names, so I can attach the relevant information to document A in one big move instead of having to individually cut and paste each piece of information (since the columns dont line up exactly because of the extra users)

b) Is there any easy way to tell which users are in document A but not B with excel?

Thanks for any and all help!

[Richard Flame]

Sure you can do both tasks

Why don't u attach a zip containing the file..I will do them for u using functions.

[sfoust]

Is the only way to combine them using a function? The information is private, so I am not allowed to send it out...

Also, is there any way to single out all of the rows with a blank value in one of the cells with a search? Thanks for any and all help!

[pinmaster]

Hi,

You can use a VLOOKUP function to retrieve the data from your second document. Say in your 2nd document in column A is your users and the data you want to import is in column B, then the formula might look something like this:

=VLOOKUP(A1,[Book2]Sheet1!$A$1:$B$10,2,0)
of course if a user is in document A is not in document B then the formula will return #NA to fix this you can use:
=IF(ISERROR(VLOOKUP(A1,[Book2]Sheet1!$A$1:$B$10,2,0)),"",VLOOKUP(A1,[Book2]Sheet1!$A$1:$B$10,2,0))

once you have all the data you need then you can use copy and paste special "value" to get rid of the formulas.

For the second question you can use something like:

=IF(COUNTIF([Book2]Sheet1!$A$1:$A$10,A1)>0,"user is in 2nd document","user is Not in 2nd document")


HTH
Jean-Guy