Lookup Functions

CyndiA

I am trying to write a function to lookup and return the status of a part from another sheet. I need the function to match information from 2 cells: the project number and the part number and return the information in the status column.

Thanks in advance for your help!

SteyJ

@CyndiA

=INDEX(COLLECT({STATUS}, {PART NUMBER}, [PART NUMBER]@row, {PROJECT NUMBER}, [PROJECT NUMBER]@row), 1)

CyndiA

Thanks for your help!

SteyJ

@CyndiA

=INDEX(COLLECT({STATUS}, {PART NUMBER}, [PART NUMBER]@row, {PROJECT NUMBER}, [PROJECT NUMBER]@row), 1)

CyndiA

Thanks for your help!

SteyJ

https://community.smartsheet.com/discussion/comment/404436#Comment_404436

Anytime 👍️