peug417 18:30 05 Apr 2003

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 2003

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.

Elsewhere on IDG sites

Fujitsu Lifebook P727 laptop review

Lightwell software lets you create mobile apps without using code

Best value Mac: Which is the best £1249 Mac to buy

Comment désactiver les programmes qui s'exécutent au démarrage de Windows 10 ?