Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2487885%22%20slang%3D%22en-US%22%3EExcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2487885%22%20slang%3D%22en-US%22%3E%3CP%3E%3DINDEX(Sheet1!%24Z%2434%3A%24Z%2449%2C%20MATCH(Sheet1!%24B%2414%2CSheet1!%24Y%2434%3A%24Y%2449%2C0))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20is%20the%20correct%20addition%20to%20the%20above%20formula%20to%20do%20nothing%20when%20Sheet1%24B%2414%20is%20empty%3F%3C%2FP%3E%3CP%3EAs%20the%20formula%20stands%20it%20matches%20the%20value%20of%20B14%20with%20the%20list%20in%20Column%20Y%20and%20outputs%20a%20graphic%20from%20Column%20Z.%20When%20B%20has%20a%20value%20this%20is%20OK%20but%20when%20B%20is%20empty%20I%20do%20not%20want%20any%20graphic.%3C%2FP%3E%3CP%3EThanks%20for%20any%20help.%20Dennis%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2487885%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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