Hi,

I've attached a worksheet which has a hlookup in cell H6. It displays the values assigned to the options in the drop down menus above it, but only does this when all three are completed. Is there a way of getting it to display when they are incomplete?

i.e.

It only shows when all three are selected like "123". When one isn't completed it shows "#NA". if two are selected and the third blank, can it show "12" or if one is selected and two are blank, can it show "1"

Suggestions appreciated

Example.xlsx