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,

	A	B	C	D	E
1	OFFICE	TYPE OF OPERATION
2	AIPORT T	=HLOOKUP(A2,D2:E4,1) =N/A		MARINE	AERO
3	ALTAMIRA			ALTAMIRA	AIRPORT T
4	MEXICO DF				MEXICO DF

<tbody>
</tbody>

 

[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