Dynamic month year in if vlookup

Help Studio
1

hi guys,
I want to extract some columns from recently downloaded file its format is like ABC_Report_ZFI_CAPI_MNO_Aug-21_Summary.xlsx basically Aug-21 is dynamic it will change every month so i used if Formula in vlookup so for dynamic date what we need to do

vlooup
vlooup2242×1298 28.7 KB

?

2

Do the month is current month or will be the previous month?

3

Replace “Aug-21” with
Date.Now.tostring(“MMM-yy”)