What is the best approach to simulate the VLookup function in a Macro.

I am writing a Macro that imports a Text File then translates the data in
each row and column to a value that my system will recognize into another
worksheet.

Currently, I have VLookup formulas that uses value in the Text File Worksheet
compares against a Cross Reference Worksheet and places the new value in
another worksheet.

The problem is the user that uses the worksheet keeps messing around with the
formula. Is there more efficent way to do this process?

Thanks
Dana

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200703/1

On Mar 2, 9:22 am, "Fredriksson via OfficeKB.com" <u27002@uwe wrote:
What is the best approach to simulate the VLookup function in a Macro.

I am writing a Macro that imports a Text File then translates the data in
each row and column to a value that my system will recognize into another
worksheet.

Currently, I have VLookup formulas that uses value in the Text File Worksheet
compares against a Cross Reference Worksheet and places the new value in
another worksheet.

The problem is the user that uses the worksheet keeps messing around with the
formula. Is there more efficent way to do this process?

Thanks
Dana

--
Message posted via OfficeKB.comhttp://www.officekb.com/Uwe/Forums.aspx/excel-programming/200703/1

Try a variable defined with Evaluate
then set the destination cell = to your variable