Please describe the logic that is to be used to get those desired results.
Please describe the logic that is to be used to get those desired results.
If you look at your column H and I you will note that there is a perfect linear correlation with
Flange diam = 0.915497124 * Velocity + 0.173924952 and I suggest this is the formula that you are wanting.
Secondly your "suggested answer" column G is wrong, you are merely showing the nearest velocity in your lookup table.
Warning a simple lookup is not going to give you the correct answer as what you are wanting is which item in Col H is closest to Col C. As an example 460 is closest to 500 then 400 but lookup will return 400 (>= but < next)
Many thanks, your suggestion is highly appreciated
Bookmarks