When you select a drop-down option it automatically updates the information relating to this in the other columns next to it.

[Leicester City Fox]

Hi All

Afternoon

In table sample below : I want my drop down list of Offences in ( Column A) and when the Offence is select the Points for that offence in ( Column B ) & Type offence in ( Column C ) both automatically get select into these columns after choosing a drop down in column A that relates to the number of point and type.

Can this be done by an excel formula and which is the easiest way to get the result below:

A (Drop Down Selected)​	B (Auto Points update)​	C (Auto Type Selected)​
Offence	Points	Type Offence
Bad Tyre's	5	Car
Failed mot	15	Car
Not Clean	3	Driver
Broken Seat	6	Garage
Late pick up	10	Driver

Many Thanks

The Leicester Fox

 

[Fluff]

If you create a lookup table, you can use

ZFluff.xlsm
	A	B	C	D									M	N	O
1	Offence	Points	Type Offence
2	Bad Tyre's	5	Car										Bad Tyre's	5	Car
3	Failed mot	15	Car										Broken Seat	6	Garage
4	Not Clean	3	Driver										Failed mot	15	Car
5	Broken Seat	6	Garage										Late pick up	10	Driver
6	Late pick up	10	Driver										Not Clean	3	Driver
Team 1

Cell Formulas
Range	Formula
B2:C6	B2	=VLOOKUP($A2,$M$2:$O$6,COLUMN(),0)

Cells with Data Validation
Cell	Allow	Criteria
A2:A6	List	=$M$2:$M$6