Results 1 to 18 of 18

Function VLookup but need Index-Match

Threaded View

thorrrr Function VLookup but need... 10-30-2013, 02:08 PM
BadlySpelledBuoy Re: Function Query Newbie 10-30-2013, 02:20 PM
newdoverman Re: Function Query Newbie 10-30-2013, 03:15 PM
thorrrr Re: Function Query Newbie 10-30-2013, 05:19 PM
thorrrr Error reply please ignore 10-30-2013, 04:00 PM
BadlySpelledBuoy Re: Function VLookup but need... 10-30-2013, 05:23 PM
thorrrr Re: Function VLookup but need... 10-30-2013, 05:49 PM
BadlySpelledBuoy Re: Function VLookup but need... 10-30-2013, 06:01 PM
newdoverman Re: Function VLookup but need... 10-30-2013, 06:02 PM
thorrrr Re: Function VLookup but need... 10-30-2013, 06:18 PM
newdoverman Re: Function VLookup but need... 10-30-2013, 06:09 PM
newdoverman Re: Function VLookup but need... 10-30-2013, 06:28 PM
thorrrr Re: Function VLookup but need... 10-30-2013, 06:35 PM
thorrrr Re: Function VLookup but need... 10-30-2013, 06:38 PM
thorrrr Re: Function VLookup but need... 10-30-2013, 06:47 PM
newdoverman Re: Function VLookup but need... 10-30-2013, 07:00 PM
thorrrr Re: Function VLookup but need... 10-30-2013, 07:24 PM
arlu1201 Re: Function VLookup but need... 10-31-2013, 05:52 AM
  1. 10-30-2013, 02:08 PM #1
    thorrrr is offline
    Registered User
    Join Date
    05-02-2005
    Posts
    56

    Question Function VLookup but need Index-Match

    Hello Guys

    Newbie query

    I need to know how to get D2 to look at C2 pick the number then refer to L, M and apply the correct formula

    Like in image A2 the Panasonic DMP-BDT230EB attracts a VAT of 2 in C2 so D2 need to look L2 and M2 and work out the 20% value.


    https://dl.dropboxusercontent.com/u/...20Function.png

    Hope it makes sense

    Thorrrr
    Last edited by thorrrr; 10-30-2013 at 04:00 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Newbie trying to introduce myself. I will followup with a query in a new thread.
    By kri54sub in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 03-10-2013, 09:56 PM
  2. newbie query
    By chakomako in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-13-2007, 12:22 PM
  3. Query based on logged on user (Newbie)
    By Tim Miller in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-20-2005, 02:05 PM
  4. I'm a newbie please help with my function
    By colincannon in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 08-09-2005, 05:05 PM
  5. [SOLVED] Newbie needs a function (how sad)
    By tjr in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 01-24-2005, 06:07 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1