Excel Vlookup

[cmoffitt]

Hello,

I'm very new to DIAdem and use Excel for much of our reporting.  We currently use Vlookup to reference the thermodynamics properties of refrigerants to calculate sub-cooling and super-heat.  Wondering what would be a good method of doing this in DIadem?  Just like everything else, probably multiple ways of doing it.  I see and understand the calculation manager, but unsure how to bring in a set of data to be used in these calculations.  I have provided the link below to show the size of the table that we would use in our typical calculations.

https://www.chemours.com/Refrigerants/en_US/products/Opteon/Stationary_Refrigeration/assets/download...

Thank you

[gsklyr]

If you have your channels set up such that each column is a channel, PNo() can help you find the index of the temperature.  From there you can use that index for other calculations using the other columns 

http://zone.ni.com/reference/en-XX/help/370858P-01/functions/functions/pno/

[Pesmith8]

Related command that will become one of your best friends for this type of issue.

Chfind

Paul

[Pesmith8]

Sorry for the spelling error  chnfind