I think what I'll do is
1) place the "found Sheet2" row-reference in a column on Sheet 2
2) return that value to Sheet1
3) then use VBA to copy/paste the resprctive Row/Cols found-range from Sheet2 to Sheet1

John C <johnc@stateofdenial wrote:

You really need a vlookup for each cell that will contain data (i.e.: 22
cells in each row will have data or 21 if not including the key, no matter
the order, you will need a formula for each cell).