+ Reply to Thread
Results 1 to 3 of 3

Unable to combine IF & VLOOKUP for multiple condition to produce Result

  1. #1
    Registered User
    Join Date
    10-14-2012
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    3

    Post Unable to combine IF & VLOOKUP for multiple condition to produce Result

    Dear Expert Excel Guru,

    I need your help on solving this puzzle as I am aware on how to use basic formula of IF and VLOOKUP but unable to think logically in combination for my data.

    Please check my data and give your suggestion or solution by overwrite my formula.

    Illustration of Table had been provided in the file as well for your better picture.

    The power of INDEX and MATCH!

    Regards,
    Kelwin
    Attached Files Attached Files
    Last edited by kelwin2504; 06-17-2013 at 11:00 PM.

  2. #2
    Forum Contributor
    Join Date
    05-09-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2013
    Posts
    259

    Re: Unable to combine IF & VLOOKUP for multiple condition to produce Result

    Hi, it maybe just me but im a little lost here! seems like you need multiple if statements. Also I maybe wrong but I would thing in cells C2 using the <36 in data validation is not going to work with an IF statement. I would suggest you shoul type this manually like 32K then you can create an IF statement like (IF C2 <="36K2,0,"")

  3. #3
    Registered User
    Join Date
    10-14-2012
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Unable to combine IF & VLOOKUP for multiple condition to produce Result

    Hi HurricaneFly,

    Please do not worry about more or less than 36k as if any card less than 36k, currently CCL Flag will automatically tag as 'O'.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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