merging help?

[kwestern]

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

​

 

[Andrew Poulsom]

Welcome to the Board.

Example formula:

=VLOOKUP(A1,SS1!A:B,2,FALSE)