Hi ander99,
From your explanation in your screenshot, here is how I interpret your question:
1. You have the data from these two Excel spreadsheets in two separate arrays. I will assume that the spreadsheet on the left is called Spreadsheet 1
2. For every element in Column A of _result, you want to find the element with equal value value in Column A of Spreadsheet 1, and extract the corresponding element in Column B of Spreadsheet 1. For example, if you want to find 1000 in Column A of Spreadsheet 1, then you want to extract the value 24.93 from Column B of Spreadsheet 1.
If I am right there, you can use the Index Array VIs to separate your 2D arrays into columns, then use the Search 1D array VI to find the element you are interested in. Then use the index of the found element, and extract the element of that index in the second column. Attached is an example VI I threw together to implement what I'm talking about (and a screenshot of it working). Notice that the found value in the first column is 0, and the corresponding output value is 10 (circled in the screenshot). Naturally you should include some contingencies for dealing with what happens if no value is found (i.e. output of the Search 1D array VI is -1).
I hope this helps.
Best regards,
Vern Yew
Applications Engineer
