row mapping

  • Thread starter Thread starter bayanbaru
  • Start date Start date
B

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?
 
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
 
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".

Max said:
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

bayanbaru said:
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?
Click to expand...
Click to expand...
 
Back
Top