Okay let me clarify a bit there needs to be 50 arguements in this formula as
there are 50 different types of Family Compliments ranging from:

Single Adult - which would equal 1 through to
Couple + 10 Children - which would equal 12



"ozgrid.com" wrote:

Use a Lookup table
http://www.ozgrid.com/Excel/lookup-table.htm



--
Regards
Dave Hawley
www.ozgrid.com
"Fab" wrote in message
...
Okay here we go.

I need to create a Conditional Formula that

1. Identifies the words i.e. Single Adult or Single Adult + 1 Child and
then
returns the number 1 or 2.

This is so I can count the people. With me so far.

Here is the issue

I have 50 Different Family Compliments (Single Adult) to do this on and
need
a formula that can handle it.

HELP - I can e-mail the spreadsheet if you need it.