Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 3 of 3 FirstFirst 123
Results 21 to 25 of 25

Thread: VLOOKUP

  1. #21
    New Member
    Join Date
    Apr 2002
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Which formula? The monster? I gave up on it and returned to the one that gave blanks if there was no match. Did the value you got come from the next highest one available?

    GDawg

  2. #22
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,653
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-05-08 07:52, GDawg wrote:
    Which formula? The monster? I gave up on it and returned to the one that gave blanks if there was no match. Did the value you got come from the next highest one available?

    GDawg
    This is the sample that you provided yourself:

    {"Item","Price";
    "B72",230;
    "B78",250;
    "B84",264;
    "B90",266;
    "B96",288;
    "BB36",120;
    "BB39",122;
    "BB42",124;
    "BB45",134;
    "BB48",142;
    "DB21",142;
    "DB24",152;
    "DB27",158;
    "DB30",164;
    "RB30",114;
    "RB33",120;
    "RB36",124;
    "RB39",132;
    "RB42",138}

    Bolded row where it looks for BB43.

    Aladin

  3. #23
    Board Regular
    Join Date
    Mar 2002
    Location
    Oregon
    Posts
    130
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I just wanted to let you guys know that I was having a similar problem yesterday and reading this thread help immensely!

    Y'all are so smart!

  4. #24
    New Member
    Join Date
    Apr 2002
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Aladin,

    Ture - if I enter BB43 it doesn't hit the next higher value but the one above that. I'm interested but don't know why it's doing that or how to change it. Otherwise the monster formular works fine.

    GDawg

  5. #25
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,653
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    Ture - if I enter BB43 it doesn't hit the next higher value but the one above that. I'm interested but don't know why it's doing that or how to change it. Otherwise the monster formular works fine.

    It's about time you get a copy the WB that uses the array formula we are discussing. Just drop me a line at:

    aladin_akyurek@yahoo.com


Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •