peug417 18:30 05 Apr 03

I am once again in need of help, although I am frustrated as i should know the answer to this:
I have a column c4 which i want to display a registration of a vehicle. instead of typing the whole reg I have created a lookup table of 1-20 in cells v6-v26 with the corresponding reg in cells w6-w26. I can't work out the formula that when I type eg 4 it inserts reg r575?
any ideas please.

  VoG™ 19:03 05 Apr 03

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…