Results 1 to 2 of 2

Thread: Vlookup,Index,Match,SumIF
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Oct 2019
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Vlookup,Index,Match,SumIF

    Hi Excelperts,
    Need help on following try to create a dashboard.

    Have herewith attached a sample file

    But first need to match data from Column H to A of Sheet 'Oct-19'
    On dashboard need following data are to be Displayed with the help Index on Sl-No in column G of Sheet 'Oct-19'
    & lock/protect the data sheets "User Front only Dashboard should be available"

    Product Name
    Batch
    Rate
    Qty
    Date
    Invoice#
    Difference of Qty from column B & K of Sheet 'Oct-19'

    from Column G,H,I & J & A,B,C,D,E,F & G

    Appreciate your inputs/help.

    Link to sheet https://docs.google.com/spreadsheets...it?usp=sharing


    Thanking you,

  2. #2
    Board Regular
    Join Date
    Oct 2011
    Posts
    4,275
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Vlookup,Index,Match,SumIF

    I see a couple of potential problems with your formula.
    1- I think you have your INDEX and MATCH range reversed.
    2- The value 11 in cell F4 of the DashBoard is numeric and the column SI-No is text, so it will not find a match.

    Once you correct either F4 to text or the SI-No column to numeric then try the formula below.

    Code:
    INDEX('Oct-19'!J3:J354,MATCH(DashBoard!F4,'Oct-19'!I3:I354,0),0)

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •