Simulating VLookUp in Macro

  • Thread starter Thread starter Fredriksson via OfficeKB.com
  • Start date Start date
F

Fredriksson via OfficeKB.com

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
 
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
Click to expand...

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