I have a Table Margin with intervals from F2:P2 ( 100, 200,300,400, up to 1200).
A1 is the Criterias A2: A12 ( 1200, 100, 300, 700 )
IF C2 is 0.50 which falls in the criteria of 1200 the point that should be from P3= 1
IF C12 is 5 which falls in the criteria of 1000 the point whould allocated is O12=9
I have tried the following formula but gives me #N/A
=INDEX($F$2:$P$18,MATCH(A2,$E$3:$E$18,0),MATCH(C2,$F$2:$P$18,0)) = #N/A
In D2 cell
Formula:
Please Login or Register to view this content.
Drag it down.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
hi there, try:
=INDEX($F$3:$P$18,MATCH(C2,$E$3:$E$18,0),MATCH(A2,$F$2:$P$2,0))
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks