Vlookup Range

[sheywood123]

Good Morning all from the UK,

I am trying to create a Vlookup to return the value from a cell that falls between the range of two others.

For example

cell value is 6 thich falls between 5 and 10 so returns 0, I dont want to list every number as this will make the spreadsheet to big?

Hopefully I have explained myself.

=vlookup(A1,Scoring,"between cells C5 and C6",FALSE)

Thanks

Sean

 

[sheywood123]

Help!

 

[VoG]

Try setting the fourth parameter to TRUE instead of FALSE (or omit it).

 

[sheywood123]

Im struggling with the between C5 and C6. as the vlookup will round down. so c6 maybe 11 and c7 will be 15

Thanks for your help.

 

[scottylad2]

if C5 is 10 and C6 is 12 vlookup with the last argument as True will return C5 10 what is your expected result?