Closed Thread
Results 1 to 2 of 2

How can I combine a VLOOKUP or an INDEX with an IF AND function for a calendar?

  1. #1
    Registered User
    Join Date
    07-14-2020
    Location
    California
    MS-Off Ver
    2016
    Posts
    30

    How can I combine a VLOOKUP or an INDEX with an IF AND function for a calendar?

    Hello! I've made progress with the help of other users however I've been trying to find a way to use VLOOKUP like column C or INDEX like column F in the Predictor for future sheet to find the estimated time in column C of the Input Data sheet to populate in the calendar section for the corresponding year and month kind of like how the code is already written. I've been trying to adjust the code for row 2 column A titled banana and row 2 column Q to populate the estimated time from the Input Data sheet. Thank you for your help!
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,002

    Re: How can I combine a VLOOKUP or an INDEX with an IF AND function for a calendar?

    This is unfonished business from your previous thread. Only one thread per topic is allowed. Thread closed. Please continue in your other thread, where you have not responded to the last reply.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Vlookup,Index matching & Ranking Combine?
    By ummmz85 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-22-2020, 03:42 PM
  2. INDEX MATCH Function for Calendar Schedule
    By khy5 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-06-2018, 09:13 AM
  3. [SOLVED] Combine vlookup or index/match with offset
    By Simon1185 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-31-2017, 03:37 PM
  4. combine TEXT function with INDEX function
    By kmbondra in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-13-2015, 12:39 PM
  5. Combine max function today() and index....
    By sakistzitzis in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-27-2014, 02:30 PM
  6. [SOLVED] Combine calendar array with a vlookup formula
    By aka 42 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-26-2013, 08:17 AM
  7. Replies: 4
    Last Post: 12-27-2012, 06:18 PM

Tags for this Thread

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