SOLVED

Number conversion

Copper Contributor

How do I get a number entered into a cell to return a value based on a range? example below

 

RangeValue    
0-1501    
151-2002    
201-2813  Number entryReturned value
282-3004  2163
1 Reply
best response confirmed by hatricke (Copper Contributor)
Solution

@hatricke 

You could arrange your data like this:

Patrick2788_0-1677620495147.png

Then use VLOOKUP with an approximate match:

=VLOOKUP(E5,A2:B5,2,1)

 

1 best response

Accepted Solutions
best response confirmed by hatricke (Copper Contributor)
Solution

@hatricke 

You could arrange your data like this:

Patrick2788_0-1677620495147.png

Then use VLOOKUP with an approximate match:

=VLOOKUP(E5,A2:B5,2,1)

 

View solution in original post