Getting VLOOKUP to cycle back to the beginning.

[turk1559]

Hi everyone, I need to assign a value from a set list of values to a line based on what score it has. Essentially, if a line has a score of 1 it gets assigned a number from one list, 2 and it gets a number assigned from another. These lists are finite and I want excel to start assigning numbers from the beginning of the list once it runs out of numbers in said list. Any advice?

 

[rahbeevt]

I guess I don't fully understand what you are trying to do. Is there a reason a normal Vlookup won't work? Perhaps providing an example or workbook might provide a little more clarification for me.