compare two spreadsheets and return a value
 

i have two spreadsheets in one book. both have the same information in
columns 'a' but in different order. i need to have the system compare the
two and then return a value that is in one spreadsheet but not on the other.
example:
spreadsheet 'x': column 'a1' - 'a 2000' is the same information as
spreadsheet 'z': 'a1'-'a2000', but not in the same order. Also in
spreadsheet 'x', column 'b1'-'b2000' has either a yes or no, but this
information is missing from spreadsheet 'z'.columns 'b1'-'b2000'. if
spreadsheet 'x' column 'a23' contains the same information as in spreadsheet
'z's column 'a56', then i want the yes or no that is listed in spreadsheet
z's column 'b56', to be copied to spreadsheet x's column 'b23'.
hope that wasn't too confusing.
Thank you ahead of time for the help.

compare two spreadsheets and return a value
 

Hi!

Enter this formula on Sheet Z in cell B1:

=INDEX(X!B$1:B$2000,MATCH(A1,X!A$1:A$2000,0))

Copy down as needed.

Biff

"thumpr" wrote in message
...
i have two spreadsheets in one book. both have the same information in
columns 'a' but in different order. i need to have the system compare the
two and then return a value that is in one spreadsheet but not on the
other.
example:
spreadsheet 'x': column 'a1' - 'a 2000' is the same information as
spreadsheet 'z': 'a1'-'a2000', but not in the same order. Also in
spreadsheet 'x', column 'b1'-'b2000' has either a yes or no, but this
information is missing from spreadsheet 'z'.columns 'b1'-'b2000'. if
spreadsheet 'x' column 'a23' contains the same information as in
spreadsheet
'z's column 'a56', then i want the yes or no that is listed in spreadsheet
z's column 'b56', to be copied to spreadsheet x's column 'b23'.
hope that wasn't too confusing.
Thank you ahead of time for the help.