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.

LG G6 review: Hands-on with LG’s bold, big-screen shot at perfection

1995-2015: How technology has changed the world in 20 years

How the painting-like animated sequences in A Monster Calls were created by Glassworks Barcelona

The 22 best Safari extensions | Best Safari plugins: Improve Apple's Safari web browser with these…