i have a cell which contain a concatenated reference/value for a brute force
lookup search..

something like this

A10 = {1,3,4,10 to 500} increasing order for "+"
the above look like a constant array but it is'nt since a single keystroke
can modify the content of A1. The number of constant may vary from 1 to 1000
only. The total characters in A1 may reach 200.

on A11 = {abc,bcd,cde,def, to abx...}
The total characters in B1 may reach 1000.

The number of constants on A10 and A11 always have the same dimension.

is it possible by any function to force a lookup function read A1 as the
lookup reference, and B1 as the lookup result.

something like
A12 = lookup("mySearchValue",""{A10}","{A11}")

please advice me of the correct formula syntax for A12, i possible...

best regards
romelsb
--
*****
birds of the same feather flock together..

typos
The total characters in (not A1) A10 may reach 200.
The total characters in (not B1) A11 may reach 1000.
--
*****
birds of the same feather flock together..



"romelsb" wrote:

i have a cell which contain a concatenated reference/value for a brute force
lookup search..

something like this

A10 = {1,3,4,10 to 500} increasing order for "+"
the above look like a constant array but it is'nt since a single keystroke
can modify the content of A1. The number of constant may vary from 1 to 1000
only. The total characters in A1 may reach 200.

on A11 = {abc,bcd,cde,def, to abx...}
The total characters in B1 may reach 1000.

The number of constants on A10 and A11 always have the same dimension.

is it possible by any function to force a lookup function read A1 as the
lookup reference, and B1 as the lookup result.

something like
A12 = lookup("mySearchValue",""{A10}","{A11}")

please advice me of the correct formula syntax for A12, i possible...

best regards
romelsb
--
*****
birds of the same feather flock together..