Function analog vlookup excel
Hello and thank you all for your time and help. I have 2 lists: "Test List 1" and "Test List 2", where "Test list 2" is created based on "Test list 1" according to the following rules:
For each item has a text property
Formula RANK = RANK(1, ASCENDING, SEQUENTIAL, TRUE, Text property)
Next, I filtered those items that have a rank =1, and created "Test List 2"
Below is a created "Test List 2"
I want for each items "Test List 1" to find item "Test List 2" according property "Text Property". The required result is indicated below in green.
I know that this problem can be solved by using as a code "Text Property" for "Test List 2". Next use function finditem(Test List 2, Text property), but in real a lenght of code is more than 60 characters, and I will have a problem, when I will create List.
Thanks in advance!!