Usint RIGHT with VLOOKUP

[jstapel1]

Hi All,

I have a field that is YYYYMM, and I am trying to convert that MM to fiscal MM. So if something comes over as 201910 the Fiscal Month should by 01 based on my table. I'm not sure how to write this


Any help would be appreciated

[AliGW]

Welcome to the forum.

=VLOOKUP(VALUE(RIGHT(A2,2)),'Fiscal Table'!$A$2:$B$13,2,0)