Excel

Brass Contributor

=INDEX(Sheet1!$Z$34:$Z$49, MATCH(Sheet1!$B$14,Sheet1!$Y$34:$Y$49,0))

 

What is the correct addition to the above formula to do nothing when Sheet1$B$14 is empty?

As the formula stands it matches the value of B14 with the list in Column Y and outputs a graphic from Column Z. When B has a value this is OK but when B is empty I do not want any graphic.

Thanks for any help. Dennis

0 Replies