Thread: Conditional Formula Words
View Single Post
  #2  
Old April 22nd, 2010, 04:07 AM posted to microsoft.public.excel.worksheet.functions
ozgrid.com
external usenet poster
  
Posts: 328
Default Conditional Formula Words
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.