Populate cell based on another.

[Grant I]

Hello.

I get a monthly report of fuel drawn by our vehicles at filling stations.

The report states that registration ABC 123 drew 100 litres, EFG 456 drew 120 litres etc. and the date and location.

I need to add details of the group the vehicle is assigned to.

Can I format a sheet to automatically pick up that CDE 234 is in group B, etc?

The report I get can't be changed by the supplier to include the group details, and with hundreds of vehicles it is not a manual task.

I can copy and paste the details of registration, fuel, location, date etc. from the report and use that information.

Thank you.

 

[Grant I]

I missed that registrations will appear on the report multiple times each month.

 

[Peter_SSs]

Welcome to the MrExcel board!

Is it something like this that you are after?

BTW, I suggest that you investigate XL2BB for providing sample data to make it easier for helpers by not having to manually type out sample data to test with.
(If you have trouble with XL2BB, review the "XL2BB Icons greyed out" link in the 'Known XL2BB issues' section near the top of the XL2BB Instructions page linked above.)

25 01 08.xlsm
	C	D	E	F	G	H	I	J	K
1
2	Registration	Group			Date	Registration	Litres	Location	Group
3	ABC 123	A				CDE 234	100		B
4	CDE 234	B				XYZ 111	90		Unknown
5	DEF 345	B				ABC 123	120		A
6						CDE 234	105		B
7
Group

Cell Formulas
Range	Formula
K3:K6	K3	=IFNA(VLOOKUP(H3:H6,C3:D5,2,0),"Unknown")
Dynamic array formulas.