You need to make a table with numbers on the left, names on the right. Say this goes in Sheet2!A1:B10.
To lookup value 9 and return Darren
=VLOOKUP(9, Sheet1!A1:B10, 2, FALSE)
or you can nreplace the 9 with a cell reference e.g. C11.
This thread is now locked and can not be replied to.
Nintendo Switch review: Hands on with the intuitive modular console and its disappointing games…
1995-2015: How technology has changed the world in 20 years
Here's what should be coming to Adobe Project Felix in 2017
Apple AirPods review: Apple's beautiful new Bluetooth headphones bring true intelligence to…
Synology invites you to visit them at Insomnia on 26th – 29th August. Book your tickets now and visit Synology.