Hi,
Just wondering if anyone could figure how I can do the following:
I have 2 columns below, One named School and the other one called Area.
My formula in the school column is: =LOOKUP($B7,{"management","hairdressing","medicine"},{"Management School","Hairdressing School","have to do further...