Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations waross on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. siclic

    Greek letters in Excel 2000

    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...
  2. siclic

    Hydro-Treated Oil

    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...
  3. siclic

    Excel VLOOKUP

    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...
  4. siclic

    Excel VLOOKUP

    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 &quot;Area&quot; lookup_value = 1000 VLOOKUP(1000,Area,2,True) &quot;Area&quot; Array values...
Back
Top