Hello All!!
I have been searching the forum, came across similar problems and various formulas and I for the life of me cannot get them to work.
I have used Index and Match and IFError in formulas and they are great. I donot think that Vlookup will work unless I arrange the Dates ...
I have 2 Tables.
Table1 has the Data I am trying to retrieve.
The Headers are: Store#, Invoice#,InvDate,PackSlip,Ven,Part#,Cost, CoreCost,TotalCost,Credit Type,Notes
table2 has the Reference Material and Fields for Retrieved Data
The Headers are:Close Date,Search Date, Store#,Vendor,Line,Part#, PInv#,P InvDate,P PckSlp,CreditAmount$
The first part of data that i am trying to retrieve is PInv#. But I need to Match the Part# during a Date Range. The "Start Date" would be the Close Date and then "End Date" would be Search Date. the field that would be checked would be InvDate on Table1
I have tried using array and standard and I am lost...
Any and all kicks in the right direction is greatly appreciated!!
I have been searching the forum, came across similar problems and various formulas and I for the life of me cannot get them to work.
I have used Index and Match and IFError in formulas and they are great. I donot think that Vlookup will work unless I arrange the Dates ...
I have 2 Tables.
Table1 has the Data I am trying to retrieve.
The Headers are: Store#, Invoice#,InvDate,PackSlip,Ven,Part#,Cost, CoreCost,TotalCost,Credit Type,Notes
table2 has the Reference Material and Fields for Retrieved Data
The Headers are:Close Date,Search Date, Store#,Vendor,Line,Part#, PInv#,P InvDate,P PckSlp,CreditAmount$
The first part of data that i am trying to retrieve is PInv#. But I need to Match the Part# during a Date Range. The "Start Date" would be the Close Date and then "End Date" would be Search Date. the field that would be checked would be InvDate on Table1
I have tried using array and standard and I am lost...
Any and all kicks in the right direction is greatly appreciated!!