Hi, I have the following table:
NameA||104442
NameB||88083|347233|347031|338267|343423|336885|
NameC||99311|284844|340289|342426|343710|340102|
NameD||160311|
NameE||70395|324542|332822
NameF||46572|324542|332822
NameG||94491|332822|275305
NameH||66492|332822|275305
NameI||189121|344050|329722|340854|341601|328744|
NameJ||130271|332822|275305|
NameK||130247|328748|328757|341693|347116|334600|
NameL||112302|340629|329351|237153|270249|330656|
NameM||239388|258806|304228|169541|
NameN||239384|275305|324542|246718|
NameO|46.5|133220|324542|246718|292132|291404|254845|
NameP|55|22356|246718|292132|291404|331287|
NameQ|-51|61895|292132|291404|344674|
NameR|-45|135534|292132|
NameS|-15|68914|291404|
NameT|-100|265364|
NameU|-35.5|51803|
Then in another worksheet, I have the following:
DestinationA|347233|Target Cell
DestinationB|347031|Target Cell
DestinationC|338267|Target Cell
DestinationD|343423|Target Cell
DestinationE|336885|Target Cell
DestinationF|284844|Target Cell
DestinationG|340289|Target Cell
DestinationH|342426|Target Cell
DestinationI|343710|Target Cell
DestinationJ|340102|Target Cell
DestinationK|344050|Target Cell
DestinationL|329722|Target Cell
DestinationM|340854|Target Cell
DestinationN|341601|Target Cell
DestinationO|328744|Target Cell
DestinationP|328748|Target Cell
DestinationQ|328757|Target Cell
DestinationR|341693|Target Cell
DestinationS|347116|Target Cell
DestinationT|334600|Target Cell
DestinationU|340629|Target Cell
DestinationV|246989|Target Cell
DestinationW|247127|Target Cell
DestinationX|239384|Target Cell
DestinationY|247108|Target Cell
DestinationZ|247174|Target Cell
This goes on for a while, heh...Anyway, in the cell above marked "Target Cell", I want a formula that will take the number in the B column, search for it ANYWHERE in the 1st table, and return the Name from the A column in the same row that it found it.
There are no duplicates of the 6-digit numbers, and the data cannot be sorted in any way, because the order has to be preserved as-is.
Thanks in advance,
HammerJ
NameA||104442
NameB||88083|347233|347031|338267|343423|336885|
NameC||99311|284844|340289|342426|343710|340102|
NameD||160311|
NameE||70395|324542|332822
NameF||46572|324542|332822
NameG||94491|332822|275305
NameH||66492|332822|275305
NameI||189121|344050|329722|340854|341601|328744|
NameJ||130271|332822|275305|
NameK||130247|328748|328757|341693|347116|334600|
NameL||112302|340629|329351|237153|270249|330656|
NameM||239388|258806|304228|169541|
NameN||239384|275305|324542|246718|
NameO|46.5|133220|324542|246718|292132|291404|254845|
NameP|55|22356|246718|292132|291404|331287|
NameQ|-51|61895|292132|291404|344674|
NameR|-45|135534|292132|
NameS|-15|68914|291404|
NameT|-100|265364|
NameU|-35.5|51803|
Then in another worksheet, I have the following:
DestinationA|347233|Target Cell
DestinationB|347031|Target Cell
DestinationC|338267|Target Cell
DestinationD|343423|Target Cell
DestinationE|336885|Target Cell
DestinationF|284844|Target Cell
DestinationG|340289|Target Cell
DestinationH|342426|Target Cell
DestinationI|343710|Target Cell
DestinationJ|340102|Target Cell
DestinationK|344050|Target Cell
DestinationL|329722|Target Cell
DestinationM|340854|Target Cell
DestinationN|341601|Target Cell
DestinationO|328744|Target Cell
DestinationP|328748|Target Cell
DestinationQ|328757|Target Cell
DestinationR|341693|Target Cell
DestinationS|347116|Target Cell
DestinationT|334600|Target Cell
DestinationU|340629|Target Cell
DestinationV|246989|Target Cell
DestinationW|247127|Target Cell
DestinationX|239384|Target Cell
DestinationY|247108|Target Cell
DestinationZ|247174|Target Cell
This goes on for a while, heh...Anyway, in the cell above marked "Target Cell", I want a formula that will take the number in the B column, search for it ANYWHERE in the 1st table, and return the Name from the A column in the same row that it found it.
There are no duplicates of the 6-digit numbers, and the data cannot be sorted in any way, because the order has to be preserved as-is.
Thanks in advance,
HammerJ