+ Reply to Thread
Results 1 to 5 of 5

Multiple Vlookup Normal Formula (not array formula) or VBA Function Required

  1. #1
    Registered User
    Join Date
    05-29-2013
    Location
    Erode
    MS-Off Ver
    Excel 2003
    Posts
    3

    Multiple Vlookup Normal Formula (not array formula) or VBA Function Required

    Hi all,

    I need a simple formula (not array formula) like SUMIFS, COUNTIFS, etc for multiple Vlookups..

    Herewith I attached sample excel file, anyone pls help me..

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    24,244

    Re: Multiple Vlookup Normal Formula (not array formula) or VBA Function Required

    What results are you expecting? Whether taxable or exempt? And are there more than 2 entries per project?
    Last edited by JohnTopley; 11-17-2015 at 02:19 AM.

  3. #3
    Registered User
    Join Date
    05-29-2013
    Location
    Erode
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Multiple Vlookup Normal Formula (not array formula) or VBA Function Required

    I have two inputs 1. Project name 2.Date of billing;

    If I enter project name is "Project A" & date is 01/10/2012 the result should be "Exempted" (Mentioned in master data Project A is Exempted from 01/07/2012 to 31/03/2015)

    and in case I enter date from 01/04/2015 to 17/11/2015 the results should be "Taxable" (Mentioned in master data Project A is Taxable from 01/04/2015 to 17/11/2015)

  4. #4
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2013
    Posts
    8,633

    Re: Multiple Vlookup Normal Formula (not array formula) or VBA Function Required

    i4=INDEX($E$4:$E$7,MATCH(1,INDEX(($B$4:$B$7=$G4)*($C$4:$C$7<=$H4)*($D$4:$D$7>=$H4),0),0))
    Please Login or Register  to view this content.
    Try this and copy towards down
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  5. #5
    Registered User
    Join Date
    05-29-2013
    Location
    Erode
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Multiple Vlookup Normal Formula (not array formula) or VBA Function Required

    Working Perfect, Thank you so much..

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Change an Array formula to a normal formula
    By jolpool in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-12-2014, 01:09 PM
  2. [SOLVED] VLOOKUP-type formula required for partial text matche in multiple spreadsheets
    By JAMES_G in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-11-2013, 04:33 PM
  3. IF function - multiple formula required
    By mikejackson in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-15-2013, 09:04 AM
  4. Vlookup/Array formula to show multiple results
    By Booms in forum Excel General
    Replies: 10
    Last Post: 09-26-2011, 12:15 AM
  5. Array Formula Vs Normal Formula
    By all4excel in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-20-2007, 02:58 AM
  6. Variable Formula - both normal and array
    By willwonka in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-26-2006, 02:40 PM
  7. Convert Normal formula to array formula
    By Pradip Jain in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-23-2005, 12:06 PM

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