Match numbers betweeen two arrays to get the index

[fahmed-2]

Hello,

I have two arrays H and H_end.Pile_vec.total. I am trying to match the numbers between these two arrays and get the corresponding index number from H_end.Pile_vec.total. I have used the match function whic works for the first one only and not for the rest. Please help. My version is Prime 10.

[Werner_E]

Its not clear what you mean by "match the numbers between these two arrays".

The error you get is easy to explain:

You will only find a match for the first three values in H and you can trap the error using "try...on error.."

So you would have to explain in more detail what you actually are trying to achieve.

[fahmed-2]

Thanks @Werner_E . This is what I needed. Based on H_end.Pile_vec.total, it will match with H and extract the indexes. How to stop at the last found index and not to show "NaN"s. Also, would later extract the arrays as values.

Thanks

[Werner_E · Accepted solution]

Hmmm, that way?

or maybe better

in case all values in H are to be found in H.end.Pile

[fahmed-2]

Thank you so much @Werner_E