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
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