Forum Discussion
caroline baldacchino
Apr 19, 2018Copper Contributor
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. ...
SergeiBaklan
Apr 19, 2018Diamond Contributor
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
Apr 26, 2018Copper Contributor
Thanks so much. That worked perfectly.