Hello,
I would greatly appreciate any assistance. I have two spreadsheets.
SS1 looks like:
A1: 20070101070044
A2: 20070101070048
B1: 2
B2: 1
SS2 looks like:
A1: 20070101070044
A2: 20070101070044
A3: 20070101070044
A4: 20070101070048
A5: 20070101070048
How would I construct a formula or another device to compare the value of SS2A1-A5 to SSA1-A2, and based on the result, paste the contents of B1 or B2 into a new cell in SS2?
Ideally, I would like to be able to have SS2 look like:
A1: 20070101070044
A2: 20070101070044
A3: 20070101070044
A4: 20070101070048
A5: 20070101070048
B1: 2
B2: 2
B3: 2
B4: 1
B5: 1
I would appreciate any help or insight.
Thank you,
Kyle
I would greatly appreciate any assistance. I have two spreadsheets.
SS1 looks like:
A1: 20070101070044
A2: 20070101070048
B1: 2
B2: 1
SS2 looks like:
A1: 20070101070044
A2: 20070101070044
A3: 20070101070044
A4: 20070101070048
A5: 20070101070048
How would I construct a formula or another device to compare the value of SS2A1-A5 to SSA1-A2, and based on the result, paste the contents of B1 or B2 into a new cell in SS2?
Ideally, I would like to be able to have SS2 look like:
A1: 20070101070044
A2: 20070101070044
A3: 20070101070044
A4: 20070101070048
A5: 20070101070048
B1: 2
B2: 2
B3: 2
B4: 1
B5: 1
I would appreciate any help or insight.
Thank you,
Kyle