Search

[Guest]

Can anybody help me!?! I need to have a formula which can search a value from
another worksheet. I need this for part of my macro, I have tried usind the
find function in excel but the macro only records the value that was in the
cell when it was recorded.

The find function would work great if there was any way of making the value
searched for the value in a particular cell.

Any help would be MUCH appreciated.

Many Thanks

 

[Dave Peterson]

You may want to post more details, but at first blush, you may be able to use
=vlookup()

It allows you to specify a value and return a value from a cell in the same row
as the matched key value.

For much better instructions, visit Debra Dalgleish's site:
http://www.contextures.com/xlFunctions02.html