address of searched element Solved/Closed

Question

Hello, 
hi
help me pls...

my question is 

--- A-----   B----   c
1  as
2  ad
3  sd
4  dg
5  ki
6  we
7  rt
8  ty 
9  ru

my question is that is there is any vba code that will give me the location of the searched element,say i searched"ki" then it wiil show result "5" in column B1 or c1 any...


Configuration: Windows XP / Safari 535.2

venkat1926 · Answer

in c1 type this formula

=INDEX($A$1:$A$100,MATCH("ki",$B$1:$B$100,0))

sunny2u86 · Answer

hi thanks  for your help but can you provide me a vbs code that will search the value in the string from range A:A100 and then give the address of the cell in which that value was found(say 5) and then store that value in a variable (say integer x)
--- A----- ----------------------B------------------------------- c 
1  thanks  for your help 
2  string from range
3 type this formula 
4 Configuration: Windows XP  
5 fan not working.
6 Address of searched element 
7 can you please help me 
8 i am waiting 
9 for your response


suppose i am searching for"working" then x integer will store 5 as the cell address, so that i'll make it uses in my calculation...

thanks!

venkat1926 · Answer

=INDEX($A$1:$A$100,MATCH("*working*",$B$1:$B$100,0))

sunny2u86 · Answer

HI

This part of code is not working..

can u provide me the vba code that automatically search the element in the range a1 to a100 and then store the result in  x integer.


thankx

aquarelle · Answer

Hi,

Try this macro :
Sub Search()
Dim word As String
Dim NRWord As Long
word = InputBox("Type word to search for :", "Search")
Cells.Find(What:=word, After:=ActiveCell, LookIn:=xlFormulas, LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
False, SearchFormat:=False).Activate
NRWord = ActiveCell.Row
Range("C1").Value = NRWord
End Sub

Best regards

venkat1926 · Answer

is not formula working
your file"sunny.xls" is uploaded here 

http://speedy.sh/sju4Y/sunny.xls


download and see C1.

Address of searched element

6 responses

Similar discussions

Subscribe To Our Newsletter!