I have a multidimensional array with 'x' rows and 3 columns of data, and I'd like to perform a VLOOKUP on the array information stored in memory rather than calling the worksheet each time. I'm just not sure how to write the code to perform the VLOOKUP using INDEX/MATCH, and repeat that process for a variable number of items in a list.
The list of values is in column 1 in the array, and I'd like to return the corresponding value in column 3 from the array (table for data in the array is below).
I have a list of values from another sheet that I'll want to VLOOKUP or INDEX/MATCH against this array. If the value in my list doesn't exist in the array, then we just need a blank or NULL value.
Can anyone point me in the right direction?
Thank you!
<tbody>
</tbody>
The list of values is in column 1 in the array, and I'd like to return the corresponding value in column 3 from the array (table for data in the array is below).
I have a list of values from another sheet that I'll want to VLOOKUP or INDEX/MATCH against this array. If the value in my list doesn't exist in the array, then we just need a blank or NULL value.
Can anyone point me in the right direction?
Thank you!
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||
<tbody> </tbody> | USD |
<tbody> </tbody> | |||
<tbody> </tbody> | USD |
<tbody> </tbody> | |||
<tbody> </tbody> | USD |
<tbody> </tbody> | |||
<tbody> </tbody> | USD |
<tbody> </tbody> | |||
<tbody> </tbody> | USD |
<tbody> </tbody> | |||
<tbody> </tbody> | USD |
<tbody> </tbody> | |||
<tbody> </tbody> | USD |
<tbody> </tbody> | |||
<tbody> </tbody> | USD |
<tbody> </tbody> | |||
<tbody> </tbody> | USD |
<tbody> </tbody> | |||
<tbody> </tbody> | USD |
<tbody> </tbody> |
<tbody>
</tbody>