Hello I have a spreadsheet which has quite a lot of data in it .
I would like it to be able when adding WD 1, WD 2, WD 3, WD 4 into column A that Column B auto populates to say Medical and for Column C to say Medicine is this possible?
and WD 5 WD 6 WD 7 to say Surgical in column B and Surgery in column C
Is this possible?
Thanking you in advance for any help is much appreciated.
I would like it to be able when adding WD 1, WD 2, WD 3, WD 4 into column A that Column B auto populates to say Medical and for Column C to say Medicine is this possible?
and WD 5 WD 6 WD 7 to say Surgical in column B and Surgery in column C
Is this possible?
Thanking you in advance for any help is much appreciated.
Input | OutPut | OutPut1 |
Ward 1 | Medical | Medicine |
Ward 2 | Medical | Medicine |
Ward 2 | Medical | Medicine |
Ward 3 | Medical | Medicine |
Ward 4 | Medical | Medicine |
Ward 4 | Medical | Medicine |
Ward 5 | Surgical | Surgery |
Ward 6 | Surgical | Surgery |
Ward 7 | Surgical | Surgery |