Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino 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: *

  • Users: joerd
  • Order by date
  1. joerd

    VLOOKUP makes a strange distinction between values and calc results

    You're right. That's awesome! Regards, Joerd
  2. joerd

    VLOOKUP makes a strange distinction between values and calc results

    @Gavona Just multiply that 0 result by 1E10 or so, and see the answer. Thanks for the link, btw. Regards, Joerd
  3. joerd

    VLOOKUP makes a strange distinction between values and calc results

    Thanks John, should've thought about that myself. Turns out that (at least in Excel 2003): (0.2+0.1-0.3) equals 5.6E-17 and not 0 Would have been nice if this had been fixed before 2007, but we're all learning. The same functionality that allows 5.6E-17 to be displayed as 0 could have been used...
  4. joerd

    VLOOKUP makes a strange distinction between values and calc results

    Yes, it's causing a problem, and no, I'm not a computer science student. The problem I presented is not my actual case, but representative of the error. The problem is that it's easy to miss the error, especially if you're doing a range lookup, and then continue working with the wrong answer -...
  5. joerd

    VLOOKUP makes a strange distinction between values and calc results

    I recently found a strange error using VLOOKUP (actually, MATCH does the same): In cell A6, type 0.1 In cell A7, type =A6+0.1 and copy down to A25 Copy A6:A25 to B6:B25 In cell C6, type =VLOOKUP(B6,A$6:A$25,1,FALSE) and copy down to C25 All looks fine, but now copy A6:A25, and paste...
  6. joerd

    How do I create more than 7 nested If statements in Excel?

    You could also try a VLOOKUP function. Regards, Joerd
  7. joerd

    excel formula newbie need help

    why not change the order of columns B and C, and then use, in cell D1 =VLOOKUP(A1,$B$1:$C$200,2,false) and copy this formula down to D2:D200 Regards, Joerd
  8. joerd

    Excel: Advanced If statements

    You have to write a visual basic function such as: Function BackgroundColor(R As Range) As Variant BackgroundColor = R.Interior.ColorIndex End Function Regards, Joerd
  9. joerd

    I have a spread sheet which calcula

    Seems to me you need something like =ROUNDUP(A1*20,0)/20 Regards, Joerd
  10. joerd

    Row data into Columns

    check out http://www.cpearson.com/excel/lists.htm or you may consider the TRANSPOSE function (quoting David McRitchie) See HELP for use of the TRANSPOSE Worksheet Function, so that you can change data on the first sheet later and be reflected in the other sheet. It will be tricky as it must be...
  11. joerd

    Excel Autosave?

    This is through an addin called autosave.xla, which should be in your office\library subdirectory. The provided addin by MS is not the greatest, there are better (also free) solutions around. Search the internet! Regards, Joerd
  12. joerd

    excel formula return type

    The type of variable returned by vlookup is the same type as the source data. So if you have text in the source data column, vlookup returns text. Sometimes, Excel treats numbers as text. So they look like a value, but it is actually a text entry. This happens - as far as I've seen - when 1...

Part and Inventory Search

Back
Top