I have about 10 sheets of information that would be the "table arrays".
I have a lookup value table that has just over 100,000 rows.
The lookup values are LARGER then the first column in the table arrays.
For example a look up value would be PL-Mary29-8x10 and the corresponding matching value in the table array is Mary29. So the corresponding matc...
Skills: microsoft excel