Help needed with excel formula

[caroline baldacchino]

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

[#2]

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.

[#3]

Thanks so much.  That worked perfectly.

[#4]

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

[#5]

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.