Select a column row value based on unique value in both the tables

[madhukarb]

Hi ,

I have 2 tables Raw Data and Process List. Based on 3 columns values of  Raw Data, i need a column value of  Process List tabel. I used SELECT(Master Process List[Site Director], AND([SITE]= [GOC Site Details],
[PODS]=[POD],[Sub POD]=[Sub Pods]),TRUE). This formula works fine when i am using only 2 conditions it doesn't work when i am using more than 3 conditions.