1

Using function 

=LOOKUP(2,1/((B8>=A1:A5)*(B8<=B1:B5)),C1:C5)

to lookup a value between two numbers doesn't seem to work in Google Sheets while in Excel it does. Does anyone know the alternative to this function in Google Sheets, please?

user1207524
  • 251
  • 2
  • 12
  • 27
  • Possible duplicate of [Selecting the last value of a column](https://stackoverflow.com/questions/4169914/selecting-the-last-value-of-a-column) – TheMaster Jul 28 '18 at 12:35

1 Answers1

3

You need to use ARRAYFORMULA:

=ARRAYFORMULA(LOOKUP(2,1/((B8>=A1:A5)*(B8<=B1:B5)),C1:C5))
TheMaster
  • 45,448
  • 6
  • 62
  • 85