On 1 sheet I have criteria in certain cells.
On another sheet I have a sorted list that contains the data that matches the cells on sheet 1.
I want the Vlookup formula to find each cell from sheet 1 that contains the criteria.......to find these cells from the list on the other sheet then look ap the corresponding value in one of the cells next to the found data and return that value.
You mention the data is a corresponding row on sheet 2 but the cells you reference indicate a column. I would guess that the data is indeed in a row. You will need to clarify in order to get an appropriate answer. Others can likely answer better and more quickly, but if the data is in 6 columns, sumproduct combined with match and index comes to mind.
My apologies. In my haste to assist you, I see that I included only the first 3 matching criteria in my formula. You can likely see how to include the last 2. If you have problems, post back and I will try to assist you.