Find markup value in dollar range 1

[jadams0173]

I'm tring to do something that is similar to thread68-1615386 but I am not having much luck. I'm using excel 2010 and I am trying to do this.

Given a lookup table

Range markup
0-10 4
11-20 3
etc

I need to take a value and return the markup. So $10.36 would return 4. $11.89 would return 3.

Any ideas how to make this work. I've started down the path in the above thread but I keep getting #N/A or #ref when I try to make it work for me.

 

[SkipVought]

Make you lookup table have SINGLE VALUES like
[tt]
Threshhold Markup
0 3
11 4
[/tt]
Then using Named Ranges based on the heading in the lookup table...
[tt]
=INDEX(Markup,MATCH(E3,Threshhold,1),1)
[/tt]
where E3 contains the Lookup Value.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

I apologise for the data not lining up in columns. This site is having some formatting problems.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[jadams0173]

Thanks SkipVought. I have it working now, many thanks!!

 

[SkipVought]

Some people like using VLOOKUP with the TRUE in the Range_Lookup argument. But I much prefer using INDEX & MATCH for lookups as it is much more flexible, when using column Named Ranges or Structured Table references in Excel 2007+

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}