OK I need to find a way to do a lookup in a table and return the entire row of information as opposed to one cell's information..<br /><br /><!--c1--><div class='codetop'>CODE</div><div class='codemain'><!--ec1-->=VLOOKUP("Data",'Data Here'!A1:B8,2)<!--c2--></div><!--ec2--><br /><br />That works the way i want it to, but I can only return one cell. I need it to return the whole row. <br />Just so you know what I'm doing with this: I have a spreadsheet with like 17 sheets (one for each of our offices) and I have to lookup data that matches a certian criteria (an entry with a status of complete) and pull it into the last page. I can do this with a vlookup and it works, but there are like 13 columns for each row, and i need to move the whole row over into the last page.
</div>
</div>