Hi everyone. I have an excel sheet with Credit and Debit columns which contain values, they cannot contain values at the same time. I have a dictionary, they Keys contain amount values, the Value contain file path values.
What I am trying to achieve:
Lets say i have a value such as: 1923 from my excel sheet, i want to match it in they dictionary key even if the value is : 000192300.
Once the number sequence matches:
- I want to write to the sheet creating a column (Confirmation status) - Yes, Then create another
column( File Path) - which would add the file path from the dictionary Value.
Want to make sure if the number is from cell A2,write all the information in the same row.
How can i achieve this