Convert formula to text

[coden23]

Hi, I have the following formula which i want to return as text for me to find it.

Sheet 1
No. Name
1 Gani Abecia
2 Nestor Santos

Sheet 2

No. Name
1 INDEX(Data!$C$9:$C$78,MATCH(B4,Data!$B$9:$B$78,0),1)

the formula will return it is gani abecia
the problem is when searching for name by pressing conrol f i can't search or find gani abecia since it is a formula. how do i do this?

thanks

 

[coden23]

Thanks Jason