# Vlookup with a repetitive data

Hi! This is my current basic formula: =VLOOKUP(\$C2,Structure!\$A\$2:\$C\$979,3,FALSE)

how do I need to adjust the formula if data in column C remains the same 14 times before it switches to another number that repeats 14 times (or goes 14 rows down)

thanks
###### Who is Participating?

Commented:
0

Commented:
=VLOOKUP(indirect("\$C"&2+14*D1),Structure!\$A\$2:\$C\$979,3,FALSE)

^ Something like that should work

D1 put 0
D2 put 1
D3 put 2 (and so on)
0

Author Commented:
nope it did not work... I am attaching file for your reference: tab "Data" column B and A need to be mapped to the Info tab. Thanks!!
Vlookup-with-repetitive-data.xlsx
0

Commented:
See attached. The 'D' rows has to be vertical
Vlookup-with-repetitive-data.xlsx
0

Commented:
There was really nothing wrong with your original formula.

Using your sample attachment, I used this formula in Data!A3...

=VLOOKUP(\$C3,Info!\$A\$2:\$C\$979,2,FALSE)

and this in Data!B3...

=VLOOKUP(\$C3,Info!\$A\$2:\$C\$979,3,FALSE)

I then copied those formulas down through A13790:B13790

0

Author Commented:
Shanan212: your formula does not work...you can use the file that you populated with the suggested formula...you can see how it changes...the idea is that one store is assigned to one region. this is what you have:
Region      Store
21      1
2      1
21      1
2      1
102      1
7      1
21      1
84      1
104      1
2      1
5      1
100      1
5      1
56      1
but they all should have region 21. Please refer to the attached file. I put filter in the "Info" tab to show that one store = one region. The thing is that in tab Data store numbers repeat 14 times before it moves on to the next number.
Vlookup-with-repetitive-data.xlsx
0

Commented:
Ok I am confused here though.

What result do you want to see? Something like this?

YOU WANT THIS? (A) OR      THIS (B)
21      1            21      1
21      1                  1
21      1                  1
21      1                  1
21      1                  1
21      1                  1
21      1                  1
21      1                  1
21      1                  1
21      1                  1
21      1                  1
21      1                  1
21      1                  1
21      1                  1
3      2             3      2
3      2                   2
3      2                   2
3      2                   2
3      2                   2
3      2                  2
3      2                  2
3      2                  2
3      2                  2
3      2                  2
3      2                  2
3      2                  2
3      2                  2
3      2                  2
0

Author Commented:
option A
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.