Compare column name and value

dnat · Post by **dnat** » Mon Nov 23, 2009 6:07 am

HI,

In the input i have 3 columns
ColA,ColB,ColC with the following values
MOS,MMS,PX

And i have a reference link(table) where all the valid values for these columns are stored in a table like below

Col1,Col2 with the following values
ColA,MOS
ColB,MMS
ColC,PX.

I want to validate whether the value in ColA(from input) i.e MOS is matching with the value in reference with the value ColA.

How can we achieve this..

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Mon Nov 23, 2009 6:38 am

Isn't that a normal lookup ?