I think index/match may be the answer to my question but I haven't been able to make it work.
What I'm trying to do:
I'm validating jobs exist at the correct time for sales.
Sheet 1 Col A: Sales part number
Sheet 1 Col B: Sales due date
Sheet 2 Col A: job part number
Sheet 2 Col B: job due date
Sheet 2 Col C: Job number. This is what I need to return.
I need to match on Sales part numbers and job part numbers AND sales due date and job due date. The twist is sales due date and job due date aren't always the same date. Job due date is usually a week or two before the sales due date.
sheet 1 col A= sheet 2 col A
and
sheet 1 col B <= sheet 2 col B (closest match)
Return Sheet 2 col C
Additional info: Data on both sheets are in a table that come from an ODBC query. No sorting applied, if possible would prefer to keep it that way - the user will be sorting so trying to avoid a formula that requires it.
Appreciate any guidance.
What I'm trying to do:
I'm validating jobs exist at the correct time for sales.
Sheet 1 Col A: Sales part number
Sheet 1 Col B: Sales due date
Sheet 2 Col A: job part number
Sheet 2 Col B: job due date
Sheet 2 Col C: Job number. This is what I need to return.
I need to match on Sales part numbers and job part numbers AND sales due date and job due date. The twist is sales due date and job due date aren't always the same date. Job due date is usually a week or two before the sales due date.
sheet 1 col A= sheet 2 col A
and
sheet 1 col B <= sheet 2 col B (closest match)
Return Sheet 2 col C
Additional info: Data on both sheets are in a table that come from an ODBC query. No sorting applied, if possible would prefer to keep it that way - the user will be sorting so trying to avoid a formula that requires it.
Appreciate any guidance.