Luk,
I tried the ASCII character codes and it wouldn't work for me either. Then I found the trick is to use the numeric keypad (on a PC keyboard). With our laptop, I had to set "Num Lock" and use the keys with the numbers in small boxes. i.e. 2 corresponds to the 'K' key.
Give...
Hi,
Take a look at the "Automotive Lubricant Engineering Forum" thread on Hydro-Treated Oil.
Basically hydrotreatment is used to improve the quality (i.e. refine) of distillates (i.e. kerosine, gas oil [diesel], and lube oils) obtained from distilling crude oil. One of the most...
Hi Guys,
Many thanks for your responses to my question. I've never used nested functions before, other than "If" functions, and have never used INDEX & MATCH. I've learned a lot from your suggestions. The final solution, for selecting a relief valve orifice size from a table of...
Hi Guys, can anyone help?
I'm using VLOOKUP in Excel 2000 to obtain a value from an array. VLOOKUP returns a value that is <= the lookup_value. I need the next highest value. e.g. in the array "Area"
lookup_value = 1000
VLOOKUP(1000,Area,2,True)
"Area" Array values...