Dear All,
I am trying to work to formulate column D to reflect an answer when a selection made on column C.
For e.g., When i select 1(column C), column D will reflect Low+Green color.
As for the color i guess, i will have to do conditional formatting, however, when i make selection the file reflects as #N/A.
Formula used : =IF(ISNUMBER(FIND($D11,"1 2 3",1)),VLOOKUP(TRIM($D11),Code!$B$1:$C$3,2,FALSE),"")
I have attached my excel, appreciate if anyone can be an assistance for me.
Also, kindly refer to tab code for the drop down option.
Many thanks guys,
Regards,
Steve
Bookmarks