I have an excel with column C1,C2,C3 and C4
I have 4 variables V1 ,V2,V3 & V4(Customised value which i will get from other xml file)
I need to check if C1= V1
If all these values are equal then corresponding C4 column value i need to take in my 4th variable V4.
Can someone please help me with this? I dont want to use for each in this case. what would be other other approach