Formula for category

[Guest1995]

Hello,

I have been trying to use HLookup to determine the category name with a table which isn't working out for me. I'm not too good using index and match. Can anyone help me out?



Thanks,

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]OFFICE[/TD]
[TD]TYPE OF OPERATION[/TD]
[TD][/TD]
[TD]

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]AIPORT T[/TD]
[TD]=HLOOKUP(A2,D2:E4,1) =N/A[/TD]
[TD][/TD]
[TD="align: right"]MARINE[/TD]
[TD="align: right"]AERO[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]ALTAMIRA[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]ALTAMIRA[/TD]
[TD="align: right"]AIRPORT T[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]MEXICO DF[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]MEXICO DF[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Peter_SSs]

Welcome to the MrExcel board!

Assuming each office can only appear once in columns D:E, try this, copied down.

Excel Workbook
	A	B	C	D	E
1	OFFICE	TYPE OF OPERATION
2	AIRPORT T	AERO		MARINE	AERO
3	ALTAMIRA	MARINE		ALTAMIRA	AIRPORT T
4	MEXICO DF	AERO			MEXICO DF
Category