I have a worksheet that I am trying to use Vlookup on to return specific info, however vlookup will stop at the first reference it sees and return that value back instead of the next one which I need. I am sure there is a way of telling it to look at the 2nd or third item in the reference array to return the specific info I need. What I am not sure of is how to tell it to do that.

help....