Hi
have a look at
application.worksheetfunction.vlookup

--
Regards
Frank Kabel
Frankfurt, Germany


John Keturi wrote:
Can I write a macro that performs like the VLOOKUP function and
assign it to a command button. I want to take value from say A1,
search another sheet 'DATA', then when it finds that value in column
1, return the value next to it in column 2. And also have the
functionality similar to FIND, in that if the user selects to
continue, it would find the next value(when there are numerous same
values, but different column 2 data).
JjK