I have two columns in worksheet Number 1 (1607 rows) as follows:

Current Value Proposed Value

0105.92.00 0105.94.00.00
0105.93.00 0105.94.00.00
0208.20.00 0208.90.25.00
0301.99.00 0301.94.00.00
0301.99.00 0301.95.00.00
0301.99.00 0301.99.01
0302.69.20 0302.67.00
0302.69.40 0302.69.50
0302.69.40 0302.68.00
0303.50.00 0303.51.00.00
0303.60.00 0303.52.00
0303.79.20 0303.79.00
0303.79.20 0303.61.00
0303.79.40 0303.79.00
0303.79.40 0303.62.00
0304.10.10 0304.19.00


I have 23 Columns in Worksheet Number 2 (42 Rows).

In this worksheet there are 2 columns as follows

Current Value Proposed Value

0105.92.00
0301.99.00
0302.69.40
0303.50.00
0303.79.20
2513.11.00
2513.19.00
2920.10.30
2920.10.40
2920.10.50
2921.12.00

I need to lookup and match the Current Value column in the 2 worksheets
and when there is a match, but no change in value in the Proposed Value
Column in the Worksheet 1 to put the words "No Change" in the Proposed
Value cell for that match in Worksheet 2.

But

If there is a change in Worksheet 1's Proposed Value for that match to
insert the Proposed Value in Worksheet 2's Proposed Value for that match.

I cannot fit all the pieces together. I tried an index and match
formula as follows:

=INDEX(B5:B1607,MATCH(D5,A5:A1607,0)), which seemed to work, but I do
not know how to include if no change in proposed value to insert "No
Change."

In testing the Index and match I copied the 2 columns in Worksheet 1 to
Worksheet 2. Do all columns need to be in the same worksheet?


I found the following example for the "No Change:

=IF(ISNA(VLOOKUP(5,A2:E7,2,FALSE)) = TRUE, "Employee not found",
VLOOKUP(5,A2:E7,2,FALSE)), but do not know who to write and incorporate
it with the index and match formula.

I would appreciate any help anyone can give me as I need to be able to
begin work on a project this coming Monday.


--
Barbara