Hi All,
I have a question regarding comparing of data from execl.
In my execl file there is 2 worksheet. One named Data Source and the other named Invoice Number.
In Data Source there are below fields:
1. Refnum (unique number)
2. FCharge
In Invoice Number:
1. BLNUM
2. FCODE
3. INVNO
In Date Source work sheet, I will like to create a field as InvoiceNo.
I need to write something to compare the below:
1st: Compare Refnum = BLNUM
2nd: Fcharge = Fcode
We need to check the first part first, if 1st part pass, then will check the 2nd part.
If both pass then in Data Source.InvoiceNo will return with the value of INVNO.
Can anyone tell me what should i do?
I got totally no idea how can i do so.
Thanks in advance.
Bookmarks