UDF add-in for difference based on related nu

Microsoft Excel 2010
September 28, 2010 at 13:00:49
Specs: Windows 7
I want to have some udf (to be added in Excel ADD - IN) which can refer the relevant number from a given file on a network location (preferable it should be accessible by multiple persons)
I dont mind even doing hard coding, but reference from file is preferable.

and for 2 given values it should give me difference.

Source Data (Related with Diamond terminology)

FL - 1
IF - 2
VVS1 - 3
VVS2 - 4
VS1 - 5

I want a function named GetPDif(P1 as String , P2 as String)

=GetPDif ( "IF" , "VVS2") shall give me the result of 2 (relevant number of IF) - 4 (relveant number of VVS2) = -2

Thanks in advance for help

See More: UDF add-in for difference based on related nu

Report •

September 29, 2010 at 10:50:18
Does it have to be a UDF?

This VLOOKUP grabs data from a file stored in a shared network folder:

=VLOOKUP(B1,'W:\TEAM\[Book3.xls]Sheet1'!$A$1:$B$5,2,0) -

If I enter IF in B1 and VVS2 in B2, I get 2

Report •

September 29, 2010 at 11:56:40
Yes, I want to implement a simple sollution, as Vlookup is little bit complex one for end users...

through UDF, it can be accessed easily..

Thanks for reply..

Report •

Related Solutions

Ask Question