VLookup returning values from a different row

I'm stumped on this one. I'm running the following formula:

=VLOOKUP("In Progress", [Phase - Task]:[Phase Status], 1)

1st column in the table is Phase - Task. VLookup finds the value "In Progress" on row 6 in the Phase status column, but then returns the value from Phase - Task from row 4. I've never seen VLookup pull data from a different row than where it found the search value.

Can anyone spot a reason why this is happening, and a potential fix? Thank you!


Best Answer

  • Leibel S
    Leibel S ✭✭✭✭✭✭
    Answer ✓

    You can use an INDEDX MATCH combo.

    This would let you put columns wherever you want.

    =INDEX([Phase - Task]:[Phase - Task],MATCH("In Progress",[Phase Status]:[Phase Status],0))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!