Forum Discussion

caroline baldacchino's avatar
caroline baldacchino
Copper Contributor
Apr 19, 2018

Help needed with excel formula

Hi I'm having trouble creating a VLOOKUP formula for a spread sheet.  

I am trying to classify the customers into categories(bronze, silver, gold) based on the information in the right hand table.  and then another vlookup formula to show their discount. I can get the correct formula for the first cell but not have it translate throughout the document

If anyone could help.

 

Thanks

 

excel

4 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Apr 19, 2018

    Hi Caroline,

     

    If I understood you screenshot correctly the formula in G4 to show discount could be

    =IFERROR(VLOOKUP($E4,$I$4:$L$7,4,TRUE),)

    , drag it down. Similar for the category.

     

    • caroline baldacchino's avatar
      caroline baldacchino
      Copper Contributor
      May 03, 2018

      Hi Sergei.

       

      Thanks so much for your help.  I am now trying to create another vlookup formula that links my order form and my product list.  I am trying to create a formula so that when I type a product code into the order form the rest of the details for that product will appear from the product list.  I have attached a screenshot of the two.  I have extracted the first line but again can't make it translate through the rest of the order form.

       

      Thanks

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        May 03, 2018

        Hi Caroline,

         

        You may use formulas like

        =IFERROR(INDEX('[Product List.xlsx]Sheet1'!$A$5:$F$12, MATCH($A10,'[Product List.xlsx]Sheet1'!$A$5:$A$12,0),4),"")

        in the first row of your form and drag them down till end of the form.

         

        Please see attached.

Resources