# Microsoft Excel Help with Text Formula

**URL:** https://forums.speedlife.net/t/microsoft-excel-help-with-text-formula/29632
**Category:** NYSpeed Off Topic
**Created:** [May 21, 2007, 12:46pm UTC](https://forums.speedlife.net/t/microsoft-excel-help-with-text-formula/29632 "2007-05-21T12:46:17Z")
**Posts on this page:** 1
**Showing post:** 6

<div class="post-metadata">

### Author: ![SilverGT](https://avatars.discourse-cdn.com/v4/letter/s/8dc957/32.png) [@SilverGT](https://forums.speedlife.net/u/SilverGT)
#### Post date: [May 21, 2007, 1:06pm UTC](https://forums.speedlife.net/t/microsoft-excel-help-with-text-formula/29632/6 "2007-05-21T13:06:38Z")

</div>

=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.

---

_[View the full topic](https://forums.speedlife.net/t/microsoft-excel-help-with-text-formula/29632)._