Hello guys,
Cant solve this function, so decided to write here. Maybe you can help me.
Situation:
Have a huge list (like a 30k+ rows). in A Column i have Numbers and in B i have Names. Basically i get a random list of names and i need to assign a exact number from list.
Example:
My database/list consists of:
<tbody>
</tbody>
and i got random list of NAMES and need assign right NUMBER (for ex. i paste that list to column C and want to get a right number to D)
<tbody>
</tbody>
I hope u get what i mean..
So anybody? I would be grateful for this.
Cant solve this function, so decided to write here. Maybe you can help me.
Situation:
Have a huge list (like a 30k+ rows). in A Column i have Numbers and in B i have Names. Basically i get a random list of names and i need to assign a exact number from list.
Example:
My database/list consists of:
A | B |
101 | Apple |
102 | Tomato |
103 | Lemon |
104 | Orange |
... | ... |
208 | Potato |
209 | Onion |
210 | Cucumber |
... | ... |
etc | etc |
<tbody>
</tbody>
and i got random list of NAMES and need assign right NUMBER (for ex. i paste that list to column C and want to get a right number to D)
C | D (need that formula) |
Potato | 208 |
Cucumber | 210 |
Apple | 101 |
Orange | 104 |
Tomato | 102 |
and etc | |
<tbody>
</tbody>
I hope u get what i mean..
So anybody? I would be grateful for this.