假設

A2 Runny nose, Fever (Mild)
A3 Cough, Fatigue, Chills, Myalgia
A4 Runny nose, Fever, Fatigue
A5 Fever (Mild), Itchy throat, Cough
A6 Cough, Fever (Mild)
A7 Myalgia
A8 Weakness, Dyspnoea
A9 Myalgia, Fever, Gastric discomfort
A10 Sore throat, Headache, Dyspnoea, Loss of smell, X-ray imaging indicates presence of pneumonia
A11

A456 D456
Body Temperature Value
Normal 0
Feeling feverish 1
Slightly elevated body temperature 2
Fever (Mild) 3
Intermittent Fever 4
Fever 5

想用A456的字串收尋A2還有A2以下 如果有收尋到傳回對等的數質 Eg A2 = 3 A4 =5
如果沒有提到的話 = 0
然後如果欄位空白 就表格也空白 Eg. A11
該如何打程序呢?
卡關了好幾個小時 謝謝