=INDEX(Enumbers!C2:C60,MATCH('final data'!B2,Enumbers!B2:B60,0))
Question:
the above formula is giving me some issues. i have a work around but it is long.
the formula is correct BUT i need to move it to several cells and the formatting of the formula must remain the same.
Enumbers!C2:C60...