INDEX & MATCH UPDATE

[Mustafa Evans]

Hi, hope that someone can help, i have a workbook that i need to update with location information (AREA, BLOCK, SHELF) from a daily data dump from a separate source.

Both data sources have a unique identifier but the workbook that i need to update doesn't have the location information i need. This appears as 3 columns (F, G, H).

The unique ID is in column A in the daily data dump (changing daily but about 900 records) and in Column E in the workbook.

The updating cell information needs to be updated into cells J, K and L on the workbook.

Many thanks in advance.

 

[mamady]

Dear Mustafa,

Please try the below, I reconstructed a sample based on your description

Book1
	A	B	C	D	E	F	G	H
1	Unique ID					AREA	BLOCK	SHELF
2	111					ABC	123	A1
3	222					EFG	456	A2
4	333					HIJ	789	A3
Source

Book1
	E	F	G	H	I	J	K	L
1	Unique ID					AREA	BLOCK	SHELF
2	111					ABC	123	A1
3	222					EFG	456	A2
4	333					HIJ	789	A3
Output

Cell Formulas
Range	Formula
J2:L4	J2	=INDEX(Source!F$2:F$4,MATCH(Output!$E2,Source!$A$2:$A$4,0))

Best Regards
M.Yusuf

 

[Mustafa Evans]

Excellent. Jazk. for the help.