How can I do an if statement based on criteria in multiple cells that auto fills a blank cell? I would like to auto populate a cell for example cell E7, based on the text in cell D7, the text in D7 could contain one of 7 different text.
Based on the text in D7 I would like E7 to auto populate one of 7 different prices from one of 7 different cells. The if statement =IF(isBlank($D7),"JP-5",$J$3) would work for populating one of the data criteria's but im not sure how to make this work for multiple values across multiple cells. The 7 prices are all located in cells along row 3.
Thanks for any help.
Aucun commentaire:
Enregistrer un commentaire