lookup with multiple criteria including date range

[pcorpz]

Hi mvps! My goal is to find out the vendor that the customer ordered from. In my lookup table (AP Report), I have the vendor name, and my criteria columns: customer name, itemnumber and the posting date. The customer and item number are exact matches, the posting date however, can be the same day, or 5 days after it was ordered. I use vlookup all the time but i'm thinking index, match.. and array formula is needed for this but no idea how to apply it!..would really like some help!

 

[Michael M]

I think you will need to post a sample of data, and a possible need / outcome result for us to at least what is required

 

[pcorpz]

I think you will need to post a sample of data, and a possible need / outcome result for us to at least what is required

Here are screenshots of my workbook: (sorry, I used the img tags but doesn't seem to work, ill post the links instead)

https://www.dropbox.com/s/t7m7vmjmehg4h8v/lookuptableap.PNG
Above is the lookup table (AP report)

https://www.dropbox.com/s/yzds6xr7dz2kimp/salesreport1.PNG
Above is where I want the value to show..