1) Can you give an example of what you're tying to do? Include any formulas
you're using and the contents of any cells they might be referencing.

2) Please don't type in all CAPITALS....(It says you're shouting at us.)

***********
Regards,
Ron

XL2002, WinXP


"johnnyz197034" wrote:

I NEED TO REFERENCE ITEMS IN A LIST FOR AN IF FORMULA HOWEVER EXCEL DOES NOT
APPEAR TO READ LISTS THE SAME AS IT WOULD IF JUST TEXT WERE IN A CELL.
ANY HELP WOULD BE GREATLY APPRECIATED!!!