Acquire index number

[fahmed-2]

Hello,

I want to assign a number in "d" from "b" in the following way. Firstly, I will input any number in "c". Secondly, I want to acquire the index number from "a" such that the value of "a" matches with the value of "c". Thirdly, Then with that, I will assign a value from "b" to "d". I can do the first and third part but cannot do the second part. It will really be helpful if you please help me out.

Faisal

[Werner_E · Accepted solution]

Something like this?

[fahmed-2]

why did you give an index "0" around the brackets ("c,a"). 

[Werner_E]

---

@fahmed-2 wrote:

why did you give an index "0" around the brackets ("c,a"). 

---

Because "Match" and also "Lookup" return a vector of values as there could be multiple values found. The vector index 0 (or you could use ORIGIN) just takes the first one.

In your example there is only one value found but the result still would be a vector, a 1x1 vector/array.

[fahmed-2]

Thank you very much