You'd be better using the VLOOKUP function.
Note also that your formula produced text strings as outputs. If you want
numbers, ditch the quote marks.
--
David Biddulph

"George" wrote in message
...
I'm fairly comfortable working within Excel; however, I just know there
must
be a work-around for multiple nesting requirements that I probably simply
just do not know of.
Specifically, I am looking for either the correct argument/formula or
"trick" to be able to complete an entry such as the following:

=IF(B18=136,"97",IF(B18=816,"97",IF(B18=160,"97",I F(B18=817,"97",IF(B18=138,"1",IF(B18=6848,"1",IF(B 18=8527,"1",IF(B18=8954,"447",IF(B18=1773,"447",IF (B18=163,"447",IF(B18=1772,"447",IF(B18=155,"448", ""))))))))))))
I would appreciate any time you are able to spend with this request.
--
Thanks.
George*