Results 1 to 2 of 2

Usint RIGHT with VLOOKUP

Threaded View

  1. #1
    Registered User
    Join Date
    06-15-2020
    Location
    Pittsburgh, PA
    MS-Off Ver
    Windows 10 Enterpri
    Posts
    1

    Usint RIGHT with VLOOKUP

    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
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 12-07-2016, 09:18 AM
  2. Using vLookup based on results from a vLookup & returning an undetermined list
    By NormalityBan in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 08-14-2014, 05:02 AM
  3. Replies: 0
    Last Post: 12-26-2013, 01:12 PM
  4. Display Cell within VLookup range that excel thinks matches the VLookup Value
    By headachexcelperson in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-04-2013, 04:56 PM
  5. [SOLVED] Using the IF formula
    By Cmorgan in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 08-16-2013, 08:00 AM
  6. vlookup? match? index? MULTIPLE criteria for vlookup search problem....
    By aborg88 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-11-2013, 09:56 AM
  7. Replies: 5
    Last Post: 07-29-2009, 07:53 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1