Sorry, time is limited (have to go out).
You need to use VLOOKUP and set the 4th parameter to TRUE so that it looks for an approximate match.
The syntax would be =VLOOKUP(4, W6:W26, 1, TRUE)
This thread is now locked and can not be replied to.
What is Amazon Go and will it come to the UK? The store without checkouts or queues
1995-2015: How technology has changed the world in 20 years
Hands-on with the Star Wars fighting drones you can fly yourself
iPhone 9 and beyond: 32 amazing future smartphone developments - graphene, supercapacitor…