Forum Discussion
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. ...
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.
Thanks so much. That worked perfectly.