Hello
Iam using below formula.. i am getting FALSE error in the CELL
=(IF($N5>0,IF(OR($AF5=$BL$5,$AF5=$BL$7),VLOOKUP($AG5,$BO$4:$BU$11,3,0)),IF(OR($AF5=$BL$6,$AF5=$BL$8),VLOOKUP($AG5,$BO$4:$BU$11,6,0),"")))
Please Help..
Hello
Iam using below formula.. i am getting FALSE error in the CELL
=(IF($N5>0,IF(OR($AF5=$BL$5,$AF5=$BL$7),VLOOKUP($AG5,$BO$4:$BU$11,3,0)),IF(OR($AF5=$BL$6,$AF5=$BL$8),VLOOKUP($AG5,$BO$4:$BU$11,6,0),"")))
Please Help..
Last edited by jayeshk; 12-19-2015 at 03:31 AM.
@Jayesh can you upload your spreadsheet once?
Shukla.. please find the attachment.. I removed unwanted and offical data so formula will differ than one i posted before.
What is your expected result and explain about the logic for level wise rates
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Try
AA3=IF(AND($E3>0,OR($Y3=$AV$4,$Y3=$AV$6)),VLOOKUP($Z3,$AY$3:$BF$10,COLUMNS($AY3:AZ3),0),IF(AND($E3>0,OR($Y3=$AV$5,$Y3=$AV$7)),VLOOKUP($Z3,$AY$3:$BF$10,COLUMNS($AY3:BC3),0),""))
Formula:Please Login or Register to view this content.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Based on the Grand total grade is generated Automatically..
once the Type is selected for Y column.Based on Type + Grade combination.. Level A,B,C and D Values should be filled from the Table on the right
For Option 1 and 2 - Level D will be Blank Always
For Option 1A and 2A - All Values will the there
For Option 3 - Only Level D is enough...
If the Total is Zero for Level repective Level - No need not show the value from the TABLE...
Formula works for Level 1 and 1A ..when paste for other i am getting FALSE..
You can simplify your formula in Column Z as follows
z3=IFERROR(LOOKUP(X3,{1,100,200,300,400,500,600,700},{"A","B","C","D","E","F","G","H"}),"NA")Please Login or Register to view this content.
shukla...
Thanks a lot.. i just modified a little.. it works...
Glad to help you
Please mark this thread as solved and you can also add reputation by clicking on star on the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks