May 23 2019 01:15 PM
I have very large source table_arrays and the cols are not always in the same position.
Can I select the "col_index_num" using a string instead of a col number?
Thanks.
=VLOOKUP(lookup_value,table_array,col_index_num,false)
=VLOOKUP(lookup value, range containing the lookup value, the column number in the range containing the return value, optionally specify TRUE for approximate match or FALSE for an exact match).
May 23 2019 07:05 PM
May 24 2019 09:56 AM - edited May 24 2019 09:57 AM
May 24 2019 10:05 AM