hi all...
how to solve this problem in lookup..
i have 3 criteria number are positive,negative, zero
all number is given and random
please attachment file
any help greatly appreciated
john m
hi all...
how to solve this problem in lookup..
i have 3 criteria number are positive,negative, zero
all number is given and random
please attachment file
any help greatly appreciated
john m
1. You need to be consistent in your table - the last Grade B you have Equal instead of Zero (I suspect that all neg's should be Bad, instead of Worst and all pos' should be good?)
Try this...
=INDEX($H$9:$H$14,MATCH(F18,$F$9:$F$14,0)+IF(G18>0,0,IF(G18=0,2,1)))
copied down
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
you're right, Ford. I missing it!!
your formula is working great!!! thank you so much
Happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks