VLookup, Multiple sheets, two criteria or conditions 0
1 (0) 0%
3 (0) 0%
2 (0) 0%
4 (0) 0%
Please this is my problem.
I have a standard sheet (StdSheet) with vendors list and amount paid daily and I want to match each transaction with the daily bank statements using the vendor ID( for example 0008222) and the amount( 345.00) . everything is in a single workbook that contain 6sheets.
-BKday1, BKday2, BKday3, Bkday4, BKday5
I will also appreciate very much if there is a way to use the VBA to solve this problem.
Thanks a lot!