Problem with Index and Match formula

[pedro-egoli]

Please let me know where I am going wrong with this

Excel Workbook
	B	C	D	E	F	G	H	I
2	*	*	*	*	GR *	G	E	C
3	Date	Symbol	item	Amount	Groceries	gas	electgricity	clothing
4	01-09-11	E	#N/A	*	*	*	*	*
Sheet1

Thanks
Pedro

 

[Sal Paradise]

It depends.

What are you expecting to get as an answer?

What are you getting as an answer?

 

[pedro-egoli]

I was looking for cell D4 to return "electricity" however, it is showing #N/A error.

What am I doing wrong?

Pedro

 

[circledchicken]

Hi,

I think you may be missing a 0 in your Match (the function defaults to 1) i.e.

=IF(B4="","",INDEX($F$3:$I$3,MATCH(C4,$F$2:$I$2,0)))

 

[p45cal]

try
=IF(B4="","",INDEX($F$3:$I$3,MATCH(C4,$F$2:$I$2,0)))

 

[pedro-egoli]

Thanks but no luck still shows the#N/A error

Pedro

 

[p45cal]

check for leading/trailing spaces in all cells concerned

 

[pedro-egoli]

That was the problem.

Thanks very much

Pedro