Results 1 to 11 of 11

Thread: VLOOKUP Problem formula not vba

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #6
    VBAX Mentor
    Joined
    Nov 2008
    Posts
    305
    Location
    xld: In your example: =INDEX(L1:L3,MATCH(2.5,K1:K3,-1))

    I don't know what the index is exactly, as it is generated by another cell.
    For example, the formula could read:
    =INDEX(L1:L3,MATCH(2.5,K1:K3,-1))
    =INDEX(M1:M3,MATCH(2.5,K1:K3,-1))
    =INDEX(N1:N3,MATCH(2.5,K1:K3,-1))
    based on the results of another lookup table elsewhere, that returns either L, M, or N.
    How do I add the L, M, or N to where I've placed the X below?

    =INDEX(X1:X3,MATCH(2.5,K1:K3,-1))
    (Just to make it even more complicated, X is on another worksheet).

    Cheers
    Last edited by Aussiebear; 12-28-2024 at 09:13 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
  •