row mapping

[bayanbaru]

I have 2 big files that I need to do mapping. File ABC has
2 column with heading A and B. I created C. File XYZ has
also 2 column heading, Y and Z.

A B C
123 1124
101 1012

Y Z
1124 Delete
1012 Permanent

If B (1124) is the same as Y (1124), then C would
be "Delete", similarly if B(1012) equal Y(1012) then C
would be "Permanent". How do I do that?

 

[Max]

Assuming both files (ABC.xls and XYZ.xls) are open

In file ABC.xls :

Put in C2: =IF(B2='[XYZ.xls]1'!Y2,"Delete","Permanent")
Copy down

 

[Max]

If B (1124) is the same as Y (1124), then C would
Clarification: I had assumed that your "similarly" above meant that
C would return "Delete" for corresponding rows down col C
- viz condition if TRUE, and with the condition if FALSE
returning "Permanent".

Assuming both files (ABC.xls and XYZ.xls) are open

In file ABC.xls :

Put in C2: =IF(B2='[XYZ.xls]1'!Y2,"Delete","Permanent")
Copy down

I have 2 big files that I need to do mapping. File ABC has
2 column with heading A and B. I created C. File XYZ has
also 2 column heading, Y and Z.

A B C
123 1124
101 1012

Y Z
1124 Delete
1012 Permanent

If B (1124) is the same as Y (1124), then C would
be "Delete", similarly if B(1012) equal Y(1012) then C
would be "Permanent". How do I do that?