Skip to main content
F
fahmed-214-Alexandrite
14-Alexandrite
April 2, 2019
Solved

Acquire index number

  • April 2, 2019
  • 1 reply
  • 1985 views

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

 

Best answer by Werner_E

Something like this?

B.PNG

1 reply

W
Werner_E25-Diamond IAnswer
25-Diamond I
April 2, 2019

Something like this?

B.PNG

    F
    fahmed-214-AlexandriteAuthor
    14-Alexandrite
    April 2, 2019

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

    W
    Werner_E25-Diamond I
    25-Diamond I
    April 2, 2019
    @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.

    Terms & ConditionsAccessibility statement