Sheet3 range A1 is initial criteria
Search for this on or the closest value in Sheet1 range CB2:DD3
If value found, look at column values in CA of the row found in, use this as the second criteria
Search Sheet3 in range W2:A2for the second criteria
Then paste all the values in the respective columns. In Sheet 3 I put filled in a couple of the columns to show how far down i need it. Thanks. Data1.xlsm
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
How can you see what you are working on when you want to see it while you to save a copy?
Add a "Save As" icon to the Quick Access Toolbar, or QAT.
That way, when you save a copy of a query, form, report, or other object you are modifying, you…