Formular for numbering when match

[issa.o]

Hi friends
i have the data in column d i need those data to given number 1 up to 87 for example if the name in column d is laalakir in column e to be 1 and if the name is bwawani to be 3 because in my source data the names are randomly what i need is only to given number as i putted manua in column e when matches with corresponding numbers
for example if is umoja it match with number 2

name match
umoja 2
sunya 3
boma sidan 4
olochaniodo 5
bwawani 6
shekina 7
nhati 8
lobosoit 9
azimio 10
ndirigishi 11
kijungu 12
njiapanda 13
namelock primary 14
kibaya 15

[FlameRetired]

Try

Please Login or Register  to view this content.

in E3 and fill down.