Hello trying to build a vba code
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.