I have a problem. I was lookin every where but im to dumb i assume hope someone here will help with macro
In first worksheet i have kind of comparission database A:J titles on first Line of course
In second i have to fill up form from A to F Just write down any numbers
How to find closest match for B2;C2;D2,E2 i search closest value for them to get Value from G, H, I column in first worksheet from Line with closest B to E
Then I need to find closest value to H to show in column K from third worksheet which has A to C.
Column A need to be same as Column G from 2nd sheet and need to download closet Sheet3 B to Sheet2 K2 and take coresponding C to L.
https://docs.google.com/spreadsheet...za1D3mUbYUa0Kkkb874sf_ATQTE/edit?usp=drivesdk
In first worksheet i have kind of comparission database A:J titles on first Line of course
In second i have to fill up form from A to F Just write down any numbers
How to find closest match for B2;C2;D2,E2 i search closest value for them to get Value from G, H, I column in first worksheet from Line with closest B to E
Then I need to find closest value to H to show in column K from third worksheet which has A to C.
Column A need to be same as Column G from 2nd sheet and need to download closet Sheet3 B to Sheet2 K2 and take coresponding C to L.
https://docs.google.com/spreadsheet...za1D3mUbYUa0Kkkb874sf_ATQTE/edit?usp=drivesdk