mercredi 7 août 2019

How to extract records from a worksheet into a seperate worksheet using VLOOKUPS and IF's

Worksheet1:

Worksheet 1 has licences with 6 columns of information - two being the start and end date.

I need a method of extracting all the records that are within 90 days before the expiry date- the idea being I want a separate alert page

I have done a IF statement that is on the end of the columns that just prints 1 if date is hits the alert criteria or 0 if not...The idea now in Worksheet2 I need some sort of VLOOKUP and IF to extract those records automatically.

How would I do this?

=IF(IFERROR(DATEDIF(TODAY(),H5,"d"),91)<90,1,0)

Aucun commentaire:

Enregistrer un commentaire