Lookups working really slowly.

Hi All,

I'm new here although have been using Mathcad since the DOS days. Mostly pretty basic stuff for electronics.

I have a document that generates 16k values. I need to use each of these to return a value from a lookup table & then process those 16k values further. The lookup table exists at the moment in an Excel file which I read into Mathcad. I then do a vlookup within Mathcad. The lookup table is 262k lines long & the sheet takes forever to run. I want to extend the lookup table to >1M values in the future.

Codei contains the 16k values I generate. DACLookup is the 262k line lookup table I import. The vlookup line surrounded by the green box is the one that takes foreever.

The only workable solution I found so far is to export my data to Excel. Use that to do the lookup & then import the values back to Mathcad for processing further. It's all very manual though.

Anyone have any ideas on how to get Mathcad to do it all but workably fast - I set the document running way before I started writing this & it hasn't finished yet!!!

Thanks, Dave.