Hello all, I want to perform a HLookup on 4 colums of data. The 4 colums of data are Large 1,2,3 and4 from a bigger pool of data (Basically the 4 highest results).

The problem is that if large 1 and large 2 are the same value - the hlookup will only lookup the first value (twice).

I hipe you can understand my problem and help provide a solution. This must have occured before?