INDIRECT formula

[Johnboy28]

Hi - is there a way to change this formula to pick up text? as I need to be able to pick up the Plan. Lookup would need to match the No and return Plan.

=IF(SUMIF(INDIRECT($C$4),A9,INDIRECT($C$6))=0,"0",(SUMIF(INDIRECT($C$4),A9,INDIRECT($C$6))))'

					No.	Wgt	Plan
	Weights & No.			1	282	FJ
	No.	Yield!f:f			2	296	JP
	Plan	Yield!h:h			3	344	FD
	Wgt	Yield!g:g			4	255	Woody
					5	242	Apple
No.	Wgt	Plan			6	156	HG
1	281.90	??			7	185	Orange
2	295.90				8	265	Woody
3	344.40				9	305	FD
4	255.00				10	288	FJ
5	242.00				11	422	JP
6	156.00				12	120	FJ

 

[RoryA]

Not with SUMIF, but you can use various lookup functions - e.g.

=INDEX(INDIRECT($C$5),MATCH(A9,INDIRECT($C$4),0))

 

[Johnboy28]

Not with SUMIF, but you can use various lookup functions - e.g.

=INDEX(INDIRECT($C$5),MATCH(A9,INDIRECT($C$4),0))

Thank you. Cant get that to work.

 

[Johnboy28]

Thank you. Cant get that to work.

Sorry about that - All good. Thank you very much for your help.