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.
so you want to type exhaust header in cell A1 and you want to return 101010010 in A1?
are your numbers and words fixed. as in will they ever change/ will you need to update them a lot?
=IF(true, result, if false result)
[quote=“ILCisDEAD,post:4,topic:29632"”]
=IF(true, result, if false result)
[/quote]
.
=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.
=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=“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
VLOOKUP, HLOOKUP ?
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=“Maksim2000,post:10,topic:29632"”]
VLOOKUP, HLOOKUP ?
[/quote]
thats what it sounds like he needs
[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.
whoops sry, forgot about this… give me 20 min lol
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…
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