VLookup, Multiple sheets, two criteria or conditions 0
-
1 (0) 0%
-
3 (0) 0%
-
2 (0) 0%
-
4 (0) 0%
Help!
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.
-standardsheet
-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!