Dealing with number ranges 11-16;21-26; 31-36

mad3

Board Regular
Joined
Sep 15, 2009
Messages
88
I want to be able to adjust a range after I have a lookup that checks what the adjustment should be. Example:
Lookup checks a rating that is -3 ( which is coming from another sheet.
The range it now needs to adjust is 21-25. When a negative number, the beginning of the range needs to drop to 14 (-3 spots back). If the lookup was 3, then range needs to increase to 32. Ideas on a function or formula to accomplish this?
The current range 21 is in column B3; the high number 25 is in b-4.
Thanks, mike in Cali...
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

etaf

Well-known Member
Joined
Oct 24, 2012
Messages
3,628
Office Version
365
Platform
MacOS
where do you want the adjusted range , if to update the lookup range then probably need VBA to overwrite and existing cell
if in a new cell ,
the lookup returns a value into cell B3 and B4
whats the lookup formula

so where is the lookup value -3

you could just have the (Lookup formula ) -+ lookup value
 

mad3

Board Regular
Joined
Sep 15, 2009
Messages
88
After the lookup and the adjustment, the final numbers are populated on a different sheet. A sheet used as the score sheet.
 

mad3

Board Regular
Joined
Sep 15, 2009
Messages
88
The lookup values are on sheet called teams. The score sheet is where I want the final values. I'm unsure how to post a portion of sheets or I would post samples.
 

Watch MrExcel Video

Forum statistics

Threads
1,090,408
Messages
5,414,228
Members
403,520
Latest member
Pineappleman

This Week's Hot Topics

Top