AutoComplete based on value in either of 3 cells

[CindyG]

I have been struggling with a change to a worksheet that has affected code that I previously used (see below). The code originally looked at one column and then, based on the value, placed the appropriate text in the subsequent adjacent cells. However, my spreadsheet may now have values in one, two or three columns (D,E and/or F). I have made several attempts at adjusting this code and am getting nowhere fast (mostly due to my lack of skill).

Any suggestions would be enormously appreciated.

Thanks very much. Original code below:

Please Login or Register  to view this content.

[p24leclerc]

I don't see what is wrong with this coe. It does what it is supposed to do.
What exactly do you need it to do? I'm not sure I understand.
Could you attached a sample file and explain what is not working as you would like?
It would help us a lot.
regards
Pierre