Hi beechum

OK, I was not looking for an argument, I was just pointing out
inconsistencies. If you really want to use an IF formula, there is only one
way of doing it in a situation like this one , and that is by using a helper
column, and then splitting the IF statement over these columns. In the first
column, you will evaluate say 6 IF statements, giving a value when true. For
the False part, give a unique number, letter or something. I like using "NOT
DONE". In the second column, you start your IF statement with
=IF(B1<"NOT DONE",B1,IF( and add the rest of the formula to evaluate the
remaining possibilities. In this way, you will either get a code, or the
words NOT DONE in the first column. In the 2nd column you will carry forward
the codes from the previous column, and also evaluate the NOT DONE ones, so
that you will have only codes in this column. Hide the first column, as you
do not need to see it, and voila.

Hth



"beechum1" wrote:


kassie.... i'll check out the vlookup command.... I of course, am just
getting started. as far as the 031 thing.... i have the IC031,
ID031... or will have had... if i were to complete proofing the
code.... all of them in alphabetical order, so that IF ic031 wasn't
found, and IF ID031 wasn't found, all the way to the XD031, then all
the remaining 031's will return the proper code... so perhaps i didn't
proof it, but it seems to me that the way i would have finalized it,
would have worked. the capitolization also is just not having been
proofed... once i found out that i couldn't use the line as is, i
didn't proof it.


--
beechum1
------------------------------------------------------------------------
beechum1's Profile: http://www.excelforum.com/member.php...o&userid=30489
View this thread: http://www.excelforum.com/showthread...hreadid=501427