# 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:** 17
**Page:** 1
### Author:  [@SilverGT](https://forums.speedlife.net/u/SilverGT)
#### Post date: [May 21, 2007, 12:46pm UTC](https://forums.speedlife.net/t/microsoft-excel-help-with-text-formula/29632/1 "2007-05-21T12:46:17Z")
well im trying to figure out a formula for excel that would let me fill out a certain item when i type in a word [Exhaust header] and if its true it will return a certain number ie[100.100.100.100]
its somethings like this
=EXACT(A2,B2)
Checks whether the strings in the first row match
if its is then a (TRUE) is return and if not a (FALSE)
so baiscally instead of it returning True or False, i want it to return a number.
there might never be a formula but any help would appricated it.
---
### Author:  [@Locutus](https://forums.speedlife.net/u/Locutus)
#### Post date: [May 21, 2007, 12:48pm UTC](https://forums.speedlife.net/t/microsoft-excel-help-with-text-formula/29632/2 "2007-05-21T12:48:30Z")
so you want to type exhaust header in cell A1 and you want to return 101010010 in A1?
---
### Author:  [@Locutus](https://forums.speedlife.net/u/Locutus)
#### Post date: [May 21, 2007, 12:49pm UTC](https://forums.speedlife.net/t/microsoft-excel-help-with-text-formula/29632/3 "2007-05-21T12:49:16Z")
are your numbers and words fixed. as in will they ever change/ will you need to update them a lot?
---
### Author:  [@ILCisDEAD](https://forums.speedlife.net/u/ILCisDEAD)
#### Post date: [May 21, 2007, 12:57pm UTC](https://forums.speedlife.net/t/microsoft-excel-help-with-text-formula/29632/4 "2007-05-21T12:57:00Z")
=IF(true, result, if false result)
---
### Author:  [@Poose22](https://forums.speedlife.net/u/Poose22)
#### Post date: [May 21, 2007, 1:05pm UTC](https://forums.speedlife.net/t/microsoft-excel-help-with-text-formula/29632/5 "2007-05-21T13:05:21Z")
[quote=“ILCisDEAD,post:4,topic:29632"”]
=IF(true, result, if false result)
[/quote]
.
---
### Author:  [@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")
=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.
---
### Author:  [@SilverGT](https://forums.speedlife.net/u/SilverGT)
#### Post date: [May 21, 2007, 1:11pm UTC](https://forums.speedlife.net/t/microsoft-excel-help-with-text-formula/29632/7 "2007-05-21T13:11:48Z")
=IF(A4\>89,“A”,IF(A4\>79,“B”, IF(A4\>69,“C”,IF(A4\>59,“D”,“F”))))
i found the formula let seee if it works.
---
### Author:  [@notch-dc5](https://forums.speedlife.net/u/notch-dc5)
#### Post date: [May 21, 2007, 1:23pm UTC](https://forums.speedlife.net/t/microsoft-excel-help-with-text-formula/29632/8 "2007-05-21T13:23:26Z")
[www.excelforum.com/](http://www.excelforum.com/)
---
### Author:  [@ILCisDEAD](https://forums.speedlife.net/u/ILCisDEAD)
#### Post date: [May 21, 2007, 1:24pm UTC](https://forums.speedlife.net/t/microsoft-excel-help-with-text-formula/29632/9 "2007-05-21T13:24:10Z")
[quote=“SilverGT,post:6,topic:29632"”]
=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.
[/quote]
[quote=“SilverGT,post:7,topic:29632"”]
=IF(A4\>89,“A”,IF(A4\>79,“B”, IF(A4\>69,“C”,IF(A4\>59,“D”,“F”))))
i found the formula let seee if it works.
[/quote]
you can’t next 30 items please don’t waste your time. Excell unfortunately has a formula limit… at least 2003 does… 2007 may not … I know 2003 had limits for cell amounts 2007 seriously didn’t seem like it did… so this may be true for the if statements to
I really don’t know what you are doing sooo making a forumula idk… more info… i could paste the formula for you
---
### Author:  [@Maksim2000](https://forums.speedlife.net/u/Maksim2000)
#### Post date: [May 21, 2007, 1:25pm UTC](https://forums.speedlife.net/t/microsoft-excel-help-with-text-formula/29632/10 "2007-05-21T13:25:18Z")
VLOOKUP, HLOOKUP ?
---
### Author:  [@SilverGT](https://forums.speedlife.net/u/SilverGT)
#### Post date: [May 21, 2007, 2:01pm UTC](https://forums.speedlife.net/t/microsoft-excel-help-with-text-formula/29632/11 "2007-05-21T14:01:20Z")
im a lazy bastard and i just want the computer to do all my work basically.
but i thought it would save me time and effort if excell could do it for me.
and i noticed yes there is a limiter on formula,
this is the next question how would i bypass the limiter?
---
### Author:  [@BaD\_AZz\_Z\_28](https://forums.speedlife.net/u/BaD_AZz_Z_28)
#### Post date: [May 21, 2007, 2:01pm UTC](https://forums.speedlife.net/t/microsoft-excel-help-with-text-formula/29632/12 "2007-05-21T14:01:54Z")
[quote=“Maksim2000,post:10,topic:29632"”]
VLOOKUP, HLOOKUP ?
[/quote]
thats what it sounds like he needs
---
### Author:  [@ILCisDEAD](https://forums.speedlife.net/u/ILCisDEAD)
#### Post date: [May 21, 2007, 2:07pm UTC](https://forums.speedlife.net/t/microsoft-excel-help-with-text-formula/29632/13 "2007-05-21T14:07:00Z")
[quote=“SilverGT,post:11,topic:29632"”]
im a lazy bastard and i just want the computer to do all my work basically.
but i thought it would save me time and effort if excell could do it for me.
and i noticed yes there is a limiter on formula,
this is the next question how would i bypass the limiter?
[/quote]
Multiple columns on a separate sheet, (toggle between them at the bottom) Do this to make it look pretty 🙂
make an if statement for as many items as you can (what ever the limit would permit) going down covering what you need. If its not in the 5… oh god this is gonna be complicated… i’ll make a spreadsheet and show you.
---
### Author:  [@SilverGT](https://forums.speedlife.net/u/SilverGT)
#### Post date: [May 21, 2007, 6:15pm UTC](https://forums.speedlife.net/t/microsoft-excel-help-with-text-formula/29632/14 "2007-05-21T18:15:59Z")
thanks ilc
---
### Author:  [@ILCisDEAD](https://forums.speedlife.net/u/ILCisDEAD)
#### Post date: [May 21, 2007, 6:28pm UTC](https://forums.speedlife.net/t/microsoft-excel-help-with-text-formula/29632/15 "2007-05-21T18:28:43Z")
whoops sry, forgot about this… give me 20 min lol
---
### Author:  [@ILCisDEAD](https://forums.speedlife.net/u/ILCisDEAD)
#### Post date: [May 21, 2007, 7:02pm UTC](https://forums.speedlife.net/t/microsoft-excel-help-with-text-formula/29632/16 "2007-05-21T19:02:36Z")
[http://www.acsu.buffalo.edu/~drcline2/randomr/Example.xls](http://www.acsu.buffalo.edu/~drcline2/randomr/Example.xls)
if its not working right let me know. its written in Open office, and some of the syntax is weird… but it should convert over…
---
### Author:  [@SilverGT](https://forums.speedlife.net/u/SilverGT)
#### Post date: [May 22, 2007, 6:06am UTC](https://forums.speedlife.net/t/microsoft-excel-help-with-text-formula/29632/17 "2007-05-22T06:06:49Z")
holy jesus, i didnt understand anything on that page. here is a referance.
i wanna search this
bag
flow
quarter
fender
susp
knee
strut
arm
shock
spindle
spring
batt
caliper
bump
abs
chassis
combo
conden
mirror
wind
brain
engine
cross
pump
diesel
head
tail
heater
hood
coil
radiator
support
door
stabli
gearbox
steering pump
a/v
lid
tire
rim
transmission
wiper
altern
regulator
column
clutch
and if it finds the right one return the part number for that item.
edit: i looked at your sheet i will adjust it to search instead of find the exact type
=IF(ISNUMBER(SEARCH(“bag”,F6)),“8708.29.30.00” i will use that search formula