rewording of formula request

[frances.reese]

Fruits Nuts Unknown (Category/Column Name)
Pear Almond Apple Row 2
Pecan Row 3
Banana Row 4

Item Category
Apple Unknown
Pecan Unknown
Banana Unknown
Pear Fruit
Almond Nuts (formula should return the Category Name of
either A(Fruits), B(Nuts) or C(Unknown) depending on which
column my item is moved to. Please let me know if this is
still not clear. Thanks for any help.

This is my formula so far, but it doesn't work if I
have "Pear" and "Almond" on the same row.
=IF(AND(A2="",B2="",C2=""),D$1,IF(AND
(A2="",B2="",D2=""),C$1,IF(AND(A2="",C2=""),B$1,IF(AND
(B2="",C2=""),A$1))))

 

[Harald Staff]

Sorry, yes, maybe just a little unclear.

What does this table do why? Why are friuts and nuts on the same row ? Your formula is
where and supposed to create which result why ? What is an item, why and how does it move
when ? What is this spreadshet intended to do ?

I honestly don't mean to nag, and I'd love to assist you once i understand this task.

 

[frances.reese]

I have a Master List of 100 ITEMS which fall under the
CATEGORY of either "Fruits", "Nuts" or "Candy".

In a separate part of a worksheet I have 4 Columns
Labeld "Fruits" "Nuts" "Candy" "Unknown". Until the
appropriate Category is determined they are temporarily
sitting in the "Unknown" column. As I move an ITEM into
the correct Category (1 of the 4 Columns) I would like my
Master List to be updated based on the Category Title
(Column) that the Items were moved into.

Example: I move Banana (Item) from "Unknown"
(Category/Column) into the "Fruit" Category/Column. My
Master List should be updated on the "Banana" row
as "Fruit",

Please keep nagging until I get this explained correctly.

-----Original Message-----
Sorry, yes, maybe just a little unclear.

What does this table do why? Why are friuts and nuts on the same row ? Your formula is
where and supposed to create which result why ? What is

an item, why and how does it move

 

[Jim]

Well, maybe you are making progress: you know no one understands your
explanation! <g> Is there a way you can post a link to the file? Perhaps
someone (or many) could download it and get a clearer picture and perhaps
some help. DO NOT post to the newsgroup, please.

 

[Jim]

I meant to say: DO NOT post the file to the newsgroup. Any and all are
invited to post questions/solutions to the newsgroups as they wish, of
course.

 

[frances.reese]

Thank you for your responses on the Newsgroup. We are
preparing to review the performance of many employees
which are broken down by their peer group (VP, Dir, Mgr,
etc.) We no longer have access to the software that was
available to us in the past, thus I am pulling together a
manual process via Excel. I will be in a meeting with the
heads of all the department. Each employee is currently
in the "Not Rated" column. As we discuss individual
employees, they will then be moved to
either "Excellent", "Strong", "Satisfactory"
or "Unsatisfactory".

Then we take a look at each of the employees in each
category and review them against each other to determine
if they really belong in that category, or if they should
be moved to a different category.

I have a Pivot Table and Chart that will read from the
Master List so we can view where our employee population
ranks on a live chart.

I really cannot thank you enough for your patience and any
help you can provide.

MY FORMULA SHOULD BE: Match John Boy (in master list cell
A55) to the table in the cell range B2:F25 and return the
value of the Category (column $B$1 or $C$1 or $D$1 OR $E$1
OR $F$1) where the mployee has been placed ("Excellent"
for John Boy)
B1 = Excellent
C1 = Strong
D1 = Satisfactory
E1 = Unsatisfactory
F1 = Not Reviewd

 

[AlfD]

Frances:

Am I right in thinking that you manually move the "Bananas" item from
the "unknown" column into the "Fruit" column?

If so, then my inclination would be to take a different approach.

A lookup table (which, when you entered bananas, would write "Fruit" in
the appropriate place) could be used also to provide the right category
for the Master sheet.

This would depend on either your knowing all possible entries of
fruits, nuts etc. To make this open-ended you would either have to make
the lookup table dynamic or edit it everytime you added a new
confection or whatever.

Alf