Search:

Type: Posts; User: btucker7587; Keyword(s):

Search: Search took 0.00 seconds.

  1. Re: Index matching multiple inputs and returning multiple results

    They both worked great!

    You guys rock! Thanks for the help!
  2. Re: Index matching multiple inputs and returning multiple results

    <tbody>
    BLDG
    ROOM
    ZONE
    BLDG
    (input)
    Room
    (input)
  3. Re: Index matching multiple inputs and returning multiple results

    Svendiamond, I got it to work, however, I had to insert a ,3 after the 0

    {=INDEX(I6:K14,MATCH(N6,IF(I6:I14=M6,J6:J14),0),3)}

    But it doesn't solve the issue of multiple zones.

    Some...
  4. Re: Index matching multiple inputs and returning multiple results

    Svendiamond, I plugged it in and I get value not valid error. I went full scale though (1900 rows) so I'll scale it down and see if I can find the error.
  5. Index matching multiple inputs and returning multiple results

    <tbody>
    BLDG

    ROOM

    ZONE

    BLDG

    (input)
Results 1 to 5 of 5