Results 1 to 9 of 9

Thread: Vlookup and Match problem

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #7
    Sir Moderator sandy666's Avatar
    Join Date
    May 2018
    Posts
    240
    Rep Power
    8
    VLOOKUP(F$26,bk,MATCH($B$24,bkt,1)+1,0)

    bk range lookup
    {"Part",13,25,37,48,73,101,145,201,2 89,600,750,1009;"DMG1",4.1,2.85,2.85,1.9,1.55,1.35 ,1.25,0.95,0.85,0.75,0.75,0.65;"DMG2",5.3,3.75,2.8 5,2.65,2.1,1.8,1.65,1.25,1.1,0.9,0.9,0.75;"DMG3",7 .05,4.6,4.6,3.45,2.65,2.15,1.9,1.5,1.25,1.05,1.05, 0.9;"DMG4",8.05,5.95,5.95,4.1,3.2,2.45,2.3,1.75,1. 4,1.2,1.2,1;"FE1",2.25,2.25,1.6,1.6,1.4,1.4,1.2,1. 2,1,0.95,0.95,0.9;"FE2",2.35,2.35,1.8,1.8,1.55,1.5 5,1.4,1.4,1.05,1,1,0.95;"FE3",2.55,2.55,2,2,1.7,1. 7,1.6,1.6,1.1,1.05,1.05,1;"FE4",2.75,2.75,2.2,2.2, 1.85,1.85,1.75,1.75,1.15,1.1,1.1,1.05;"HTECH1",2.8 8,1.77,1.77,1.77,1.14,1.14,0.91,0.91,0.78,0.66,0.6 ,0.55;"HTECH2",4.6,2.25,2.25,2.25,1.43,1.43,1.28,1 .28,1.02,0.84,0.76,0.69;"HTECH3",6.66,2.74,2.74,2. 21,1.71,1.62,1.62,1.62,1.27,1.02,0.93,0.84;"HTECH4 ",8.05,3.11,3.11,2.5,2.04,2.04,1.98,1.98,1.51, 1.2, 1.09,0.98} with index for DMG1 = 14 (in range lookup)
    MATCH is a column index
    too many indexes but I'm an old idiot and mixed indexes
    anyway problem is solved by last argument 0 (-1, 1) or defined (mandatory) place for last argument after comma

    EDIT:
    I still see 5 reps not 1000
    Last edited by DocAElstein; 10-02-2022 at 03:33 PM. Reason: Just made "DMG1" purple to match mine, that's all
    sandy
    I know you know but I forgot my Crystal Ball and don't know what you know also I may not remember what I did weeks, months or years ago so answer asap. Thinking doesn't hurt

Similar Threads

  1. Replies: 0
    Last Post: 07-05-2017, 09:28 PM
  2. Convert All Vlookup formulas to Index-Match in a worksheet
    By littleiitin in forum Download Center
    Replies: 0
    Last Post: 03-17-2016, 06:50 PM
  3. InputBox OK and Cancel Button Problem
    By mackypogi in forum Excel Help
    Replies: 5
    Last Post: 05-30-2014, 12:20 AM
  4. Problem with line (row) in a macro
    By k0st4din in forum Excel Help
    Replies: 1
    Last Post: 03-19-2014, 07:59 AM
  5. Formatting Problem while copying data
    By princ_wns in forum Excel Help
    Replies: 3
    Last Post: 04-03-2012, 07:18 PM

Posting Permissions

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