Hi guys.

iam trying to create a formula that allowds to write a word in a cell ( a1)
and sends me to the specifc arrow where the word can be found. Imagine that i
write Abn Amro on the cell and it sends me to the place where that name or
word can be found 9 (a89 for example)

Many thanks !!!!

Why not just use CTRL+F to find the word you're looking for?

"andre guerreiro" wrote:

Hi guys.

iam trying to create a formula that allowds to write a word in a cell ( a1)
and sends me to the specifc arrow where the word can be found. Imagine that i
write Abn Amro on the cell and it sends me to the place where that name or
word can be found 9 (a89 for example)

Many thanks !!!!

well iam trying to create a more acessible data base for others to use. they
will not remenber to do that so i tried to create a Search data field in one
cell but couldn´t managed it. Help me with this mate! ty Again

"Dave F" wrote:

Why not just use CTRL+F to find the word you're looking for?

"andre guerreiro" wrote:

Hi guys.

iam trying to create a formula that allowds to write a word in a cell ( a1)
and sends me to the specifc arrow where the word can be found. Imagine that i
write Abn Amro on the cell and it sends me to the place where that name or
word can be found 9 (a89 for example)

Many thanks !!!!

Well, I don't know of a function that will do what you're looking to do, but
why not record a macro that opens up the Find dialog box (the window you get
when you hit CTRL-F) and assign that macro to a button which you place at the
top of the screen?

Alternatively you could create a user defined function but I'm not sure what
the code for that would be.

Sorry I can't be of more help.

Dave

"andre guerreiro" wrote:

well iam trying to create a more acessible data base for others to use. they
will not remenber to do that so i tried to create a Search data field in one
cell but couldn´t managed it. Help me with this mate! ty Again

"Dave F" wrote:

Why not just use CTRL+F to find the word you're looking for?

"andre guerreiro" wrote:

Hi guys.

iam trying to create a formula that allowds to write a word in a cell ( a1)
and sends me to the specifc arrow where the word can be found. Imagine that i
write Abn Amro on the cell and it sends me to the place where that name or
word can be found 9 (a89 for example)

Many thanks !!!!