VLookup, Multiple sheets, two criteria or conditions

  • VLookup, Multiple sheets, two criteria or conditions 0

    1. 1 (0) 0%
    2. 3 (0) 0%
    3. 2 (0) 0%
    4. 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!