=IF(A2=“Davolio”,“OK”, “Not OK”)
this is a similar formula but i have a list of 30 items has to compare it to, and then return the part number that corresponds to the 30 items it has to compare it too.
so baiscally i will type in exhaust in A1 and it will compare it to a list of about 30 item, and when it finds a match it willl take the part number for that part.
i hope that wasnt confusing.
i remeber doing this in c++ but i dont know if it works on excell
like if its not this then it will go to the next if line. do excel have something liek taht.