I'm trying to use the LOOKUP function to fill a "fault type" column based on what the "fault description" is. I'm currently using the formula
=LOOKUP(E2, M3:N17) which is returning a value from my look-up table, but it is incorrect. Here is a screenshot of my spreadsheet can anyone suggest what I'm doing wrong?
For context, I'm using a spreadsheet to record IT helpdesk problems (I know a database would be more efficient, but I'm a student and the exercise requires me to use Excel)