Results 1 to 7 of 7

Adding another IF statement

Threaded View

andy2707 Adding another IF statement 09-17-2019, 03:35 AM
PaulM100 Re: Adding another IF... 09-17-2019, 03:39 AM
Pepe Le Mokko Re: Adding another IF... 09-17-2019, 03:40 AM
andy2707 Re: Adding another IF... 09-17-2019, 03:56 AM
PaulM100 Re: Adding another IF... 09-17-2019, 04:32 AM
andy2707 Re: Adding another IF... 09-17-2019, 04:38 AM
andy2707 Re: Adding another IF... 09-17-2019, 05:33 AM
  1. #1
    Registered User
    Join Date
    09-17-2019
    Location
    Brisbane, Australia
    MS-Off Ver
    Office365
    Posts
    9

    Adding another IF statement

    Hi there,

    If I am duplicating a post, I am sorry, there are so many on here and I do not know what words to search with

    I am simply using a VLookup, but am stuck

    =IF('datasheet'!$L2=1,VLOOKUP($A5,'datasheet'!$A$2:$T$500,14,0),0)

    The reason for the IF, is that there are two data sets I want to refer to based on L2.

    Where I need help is that I need to edit the above formula so that the output also looks at the month of each row which is 'datasheet'!D2:D500

    Hope this make sense???
    Last edited by andy2707; 09-17-2019 at 05:32 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Adding an IF statement into an existing IF OR statement
    By Kogen in forum Excel General
    Replies: 4
    Last Post: 09-11-2018, 11:57 AM
  2. [SOLVED] Adding OR statement into If statement
    By ScabbyDog in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-28-2016, 08:31 AM
  3. Adding CountIf Statement within If/ElseIf Statement
    By freybe06 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-17-2014, 05:09 AM
  4. Help adding an IF statement?
    By jawnmallon in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-24-2013, 09:13 PM
  5. [SOLVED] Adding an if statement to vba and adding 1 onto the cell value
    By Nicola13 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-21-2012, 05:13 AM
  6. Adding an OR statement for a value
    By garopro in forum Excel General
    Replies: 4
    Last Post: 12-07-2011, 05:30 PM
  7. IF Statement + adding
    By burblecut in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-02-2008, 11:50 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