what is the suitable function
I have 2 sheets, the first one is a table that shows the following
and I have another sheet all what i need when i write the values in the first and the second column the data in the third columns appear
what suitable function could be used
Best Answer

Try an INDEX/COLLECT like so:
=INDEX(COLLECT({Area Column}, {Plot Column}, @cell = Plot@row, {Valve Number Column}, @cell = [Valve Number]@row), 1)
Answers

Try an INDEX/COLLECT like so:
=INDEX(COLLECT({Area Column}, {Plot Column}, @cell = Plot@row, {Valve Number Column}, @cell = [Valve Number]@row), 1)

it works well
thank you very much

Happy to help. 👍️

please could you explain each part of this syntex

You COLLECT all of the rows from the first range where the range/criteria sets match then you INDEX the first one from the array.

thank you, but I'm still struggling in understanding functions and formulas what is your advice regarding that
how to apply what is in my mind using functions and formulas

The previously suggested formula should be pulling in exactly what you are wanting.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.2K Get Help
 360 Global Discussions
 199 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 444 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!