Hi everyone

here is an example of what the massive data looks like

A (sheet 1)     B(sheet 1)          A(sheet 2)      B(sheet 2)
store              states                  store             states
1                      -                          4
MN
2                      -                          3
TX
3                      -                          1
CA
4                      -                          2
SD
5                      -                          6
MI
6                      -                          5
AL

What I want to do is to match the store# from column A (sheet 1) with
store# from column A(sheet 2) and then insert the corresponding states
into column B (sheet 1). The data is so massive that it is impossible
to get it done this week. Could someone help with this? I'll greatly
appreciated.

NT