Hi,
Got a problem I hope someone can help me with if only I can explain myself................
200 200 35
250 250 37
300 300 40
350 350 43
400 400 46
450 437← 50←
550 500 53
600 550 56
650 600 60
700 650 62
437 (← Variable Number)
The first column is a list of numbers, the last one (437) of which is variable, calculated by a simple formula. The second column has these same numbers ranked from lowest to highest using VLookUp.
What I need is to do simple calculations with the second row & the third row, but moving the third row up & down so that the variable number is always matched up with 50 in the third column. So if the variable number was 325 for example rather than 437 is would look like this:
35
37
200 200 40
250 250 43
300 300 46
350 325← 50←
400 350 53
450 400 56
500 450 60
550 500 62
600 550 64
650 600 66
700 650 68
325 ← (Variable Number) 70
If anyone can help I'd be really grateful,
Liam
Bookmarks