I am really sorry I have left msg here a week ago but I can not find it now.
I found out what I need to do.
Here is example
A B C D
1 222 333 343
OK if I put 1 in A1 it is going to show above for columns B, C, and D
If I put 2 in A different numbers will show and so on for 6 categories.
Now if it is 2 and in be for wxample should be 454, in A 12 should put them
in categories. Category 1 (if A=1 B=222) should say Category 1, if it is 332
It is still category1.
Here is my formula =IF(B271109,"Category 1",IF(B27800,"Category
2",IF(B270,"Category 3",""))) this is only if A-1 but for A=2 it should be
=IF(B271300,"Category 1",IF(B27200,"Category 2",IF(B270,"Category 3","")))
and so on for 6 different categories
But for example A=2 B=454 it should be Category 1 also for example. So how
do I make it say Instead Category 2 Category 1?