Hi Guys, I have a Vlookup on an Excel Cell containing several IDs. I use the look up on the Previous Day's speadsheet to see what the position is on the trades. See below
15th of Oct
1909843.28, 2222646.28, 2222836.28, 2224190.28, 2224281.28
16th of Oct
2224281.28, 1909843.28, 2222646.28, 2222836.28, 2224190.28
The Problem is the sequence of the trades IDs randomly switches from one day to the next due to a system bug so my Vlookup does not work. Is there a way that irrespective of any change in the order of the trade ID, the Vlookup could still work?