|Since you still haven't given us much detail, all I can do is ask...|
If VLOOKUP works, why are you looking for another method?
Until we know more about your worksheets and exactly what you are trying to do, there's not much we can offer.
Keep in mind that we can't see your workbook from where we're sitting nor can we read minds.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.