Good day everyone,

Thank you for sharing this kind of platform to help others, many thanks.

I need to return a value from 2 worksheets using Vlookup and the DATEDIF function. I thought of these two as I have previously used these functions but apart from each other.

Here is the scenario:

2 x Worksheets:

**Helios Report - Upgrades** where I need to use the start date subtracted by date from a drop down selection in the worksheet called **EPPIX Validation**. I need to subtract the dates in order to see how old a particlular promotional deal was used in months. However, the data is not in the same format between the 2 worksheets therefore I will need to also look for a specific value and the value I am trying to match will be the customer mobile number. Here is what I have so far:

=VLOOKUP(DATEDIF(AE18,'Helios Report - Upgrades'!E14,"M"),'EPPIX Validation'!S18,'Helios Report - Upgrades'!A$:A$,1,FALSE))

By selecting the date from the drop down, there are 2 other fields that will auto populate depending on the correct formula. The cells should return the number of months between the 2 dates as well as status of either, "**Finding**" or **No Finding**" with condtuional formatting.

I have attached an example, and highlighted the headings in Yellow. Not sure if there is another way around this, but I am sure there is. My challenge is joining 2 formulas from multiple worksheets to return a specific value.

You will notice I already have a formula worked in, but this is only referencing one worksheet, I need to reference between the two.

Your help is greatly appreceiated and thank you for considering to help me.

Warm wishes,

JCvR