# Help identify position on graph

1. ## Help identify position on graph

Hello All,
On the attached, you will see I have 10 customers listed with a Gross List Price value and a discount value. On the second sheet ("parameters"), you will see that I have three measures that correspond to the discount level (Out of Bounds, Left fairway, and Right Fairway) and also a Gross List Price Value.
Here is what I am after-
I need to come up with a way to identify where these values would plot on a graph for each of my 10 customers. For instance, Applied Materials has a Gross List Price of 81M and a discount of 96%, if I switch over to my "parameters" worksheet, I would see that this customer would be plotted as "Out of Bounds" since the Gross List Price is over 10M and the discount is 96%. Is there a way to do this with a formula rather than the way I have been doing it manually?

Any and all help is greatly appreciated!
Thanks!
Andrew

2. ## Re: Help identify position on graph

In your sample, all but the last row of the table can be deleted, as NONE of the values are less than 10M. However, assuming that some can, on occasion, be less than 10 M...

=IFERROR(INDEX(Parameters!\$A\$1:\$C\$1,MATCH(1,--(INDEX(Parameters!\$A:\$C,MATCH(C2,Parameters!\$D:\$D,1),)< Sheet1!B2),0)),"Out of Scope")

However, even that doesn't cover 3 sets of values that are NOT covered by your definition.

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1