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.  ...
excel
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