VLookup - How to return Multiple rows AND Columns?

[DUrekew]

I have two sheets; Sheet 1) has a large qty of data in multiple rows and columns (Shipping Data), but the basic information I need to match to this sheet are the Part Numbers; they are confirmed to be the only part numbers with a certain material specification I'm interested in. Sheet 2) has the reject data, again multiple rows and colums (rows for incidents, columns for fields of USEFUl information for each incident). Is it possible to perform a VLookup that pulls every Incident & field for events that correspond to the part numbers listed in sheet 1)?

Any help is appreciated in advance!

Thanks, David!

 

[jerbaldw]

This is difficult without seeing the workbook / format. Have you tried using a INDEX & MATCH formula? Something like this:
=INDEX ( Column I want a return value from , ( MATCH ( My Lookup Value , Column I want to Lookup against , Enter “0″ ))
then hit CNTRL+SHFT+ENTER

If you can send the workbook, you can PM your email and I will respond where to send the workbook. I could easily do this with VBA if no easy insheet formula can be used.