Here is the situation: I need to replace the standard vlookup funtion in a cell, with code that is executed with a button. Basically the code will do the same thing - the variable will be defined in the first part of the code - the second part of the code will look through a list of data on worksheet2, with the variable in the first part serving as the key. When it finds that variable, the data in the adjacent cells on worksheet2is returned to cells on worksheet1.
Thanks-
-Dan
Thanks-
-Dan