Hello,

I used the translation service Google translate.

In the attached file

In issue 1 I want to locate a drug name (column C) by 2 VLOOKAP:

Thesis in column number a

Column Date B (when here you are looking for any date that was in the last year back from that period)

The data from sheet 2-column E should be collected this is the answer

I don’t fully get what you mean with ”… any date that was in the last year …”. Can you give some examples to clarify what you want?

Anyway, VLOOKUP is not the best function for this kind of scenario, based on your data structure, XLOOKUP or INDEX & MATCH are.

Some good articles that should help you forward.

https://www.myonlinetraininghub.com/vlookup-using-dates-multiple-values

https://www.myonlinetraininghub.com/excel-factor-entry-4-index-and-match-two-criteria

https://www.myonlinetraininghub.com/excel-xlookup-function

A similar issue discussed in this thread.

https://www.myonlinetraininghub.com/excel-forum/excel/lookup-values-both-day-and-time

Br,

Anders