VLOOKUP Formula (Lookup value and Lookup vector are in the same range )

Hi,


Please find the attached sample file. How to extract status from previous month to current month and vice versa using VLOOKUP formula. Previous month data and Current month data are in the same range.

Explanation :

* Need to extract status from Current month (and) Need to extract status from Previous month
i) in first scenario, B2:B21 are lookup values , B22:C40 is Lookup Vector
ii) in Second scenario, B22:B40 are lookup values , B2:C21 is Lookup Vector

* If current month return value (result range: D22:D40) is #N/A then we should consider that error value as "New"
* If Previous month return value (result range: D2:D21) is #N/A then we should consider that error value as "Deleted"


Any help would greatly appreciated.


Note: For your reference, I added sample output data in the attached file(N2:Q41)


Regards
Raj Kumar