Update a column in Excel Spreadsheet

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

There are two worksheets in a workbook.

And we have to update a specific column to Y in worksheet
1 according to the values of a column in worksheet 2.

We would like to know what function should we use.

Thank you for your help.
 
Maybe my question is not clear.

Worksheet 1
121 Y
122 N
123 N
124 Y
125 N
126 N
127 N

Worksheet 2
123
125

I want to update Worksheet 1 so that it becomes:
Worksheet 1
121 Y
122 N
123 Y
124 Y
125 Y
126 N
127 N

Thanks
 
Try typing this formula in B1 in sheet 1

=IF(ISERROR(MATCH(A1,Sheet2!$A$1:$A$10)),"N","Y")

where in sheet2 in range A1 to A10 you are going to write the valid
numbers.

Hope this helps
 
This fits your scenario as long as your data is 3 numbers plus alpha.

Enter in B1 of Sheet1, and drag down to copy:

=IF(ISNA(MATCH(LEFT(A1,3),Sheet2!$A$1:$A$7,0)),A1,LEFT(A1,3)&"Y")

*IF*, the characters on Sheet2 are *true* numbers, try this:

=IF(ISNA(MATCH(--LEFT(A1,3),Sheet2!$A$1:$A$7,0)),A1,LEFT(A1,3)&"Y")
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



Maybe my question is not clear.

Worksheet 1
121 Y
122 N
123 N
124 Y
125 N
126 N
127 N

Worksheet 2
123
125

I want to update Worksheet 1 so that it becomes:
Worksheet 1
121 Y
122 N
123 Y
124 Y
125 Y
126 N
127 N

Thanks
 
Back
Top