Hi All
I have multiple columns and each cell in that particular column has further option of selecting a value from a Drop down list. Based on the values in the cells and combining it with cell value in other cells, i want to publish the final status which is fixed...i have tried using multiple IF and AND function but no success....Would request you to please help...Excel is attached here for reference..Sample Excel Problem.xls
Last edited by kushal4698; 03-05-2012 at 10:11 AM. Reason: As per Rule 1 of the Forum
Hi, could you have the read of the forum rules and give your thread a title which describes the problem, as per rule #1, please?
In the meantime, you could try this:
=IF(SUMPRODUCT(--(C3:G3="")),"",INDEX('Health Status - Fixed'!G:G,SUMPRODUCT(ROW('Health Status - Fixed'!$A$3:$A$34),--('Health Status - Fixed'!$B$3:$B$34=C3),--('Health Status - Fixed'!$C$3:$C$34=D3),--('Health Status - Fixed'!$D$3:$D$34=E3),--('Health Status - Fixed'!$E$3:$E$34=F3),--('Health Status - Fixed'!$F$3:$F$34=G3))))
I wrote a formula in cell H -->
=SE(C3="";"";SE(D3="";"";SE(F3="Yes";"Unhealthy";SE(G3="No";"Unhealthy";"Healthy")))).
The term SE is the "IF", I have the excel with Portuguese language.
After you convert the formula, you just hate to copy down the formula.
I hope to help.
Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
The post title has been changed as per the Forum rules.
@Andrew-R - Thank you for your response. I copy-pasted the formula in Column H. Surprisingly, it didnt worked for second row but was fine for 1st & 3rd row (refer the attached image).
@NGUIMARAES - - Thanks for your help. I used the formula after changing SE to IF, it didnt work though i will try again...
You haven't attached an image, so I can't see the problem. The formula was designed to be pasted into row 3, but should work fine when copied up or down from there.
With Ngiumaraes' formula you'll have to change the ";" to "," throughout, but his formula isn't doing what you wanted.
excel problem pic.jpg Here is the pic Andrew. See if you can get to the root cause...
Your lookup table has two rows that contain the combination Apple/Tomato/No/No/No - rows 27 and row 30, so the sumproduct returns the sum of them (57), which is a blank row.
Deleting either row 27 or row 30 from your lookup table will fix the problem.
Sample Excel Problem_alt.xlsx
Hi I sent a file could see it answer to your question.
Thanks Andrew, NGUIMARAES for your responses. However, i am still facing the difficulty. I tried to replicate the formula but it didnt work. I am now attaching the actual file for which i need help...
"Sample System" tab will have a list of systems for which we will receive the response in Columns D to I. A unique combination in this tab will have a RAG status attached to it which I want the excel to look from "Fixed Combinations" tab and return the result from Column H of this tab in the "Sample System" Column J. Please if anyone can help me i shall be very thankful..Sample Sheet.xlsx
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks