Need to extract lookup value from Column with Value

[jim may]

I need to create a Sumproduct() formula in Col G and part of it needs to reference the related Row 1 text where there is a value in Col B to Col F
on rows 2-5. Not sure right off as tho how to do this; Perhaps use of Match
Any help appreciated.

Jim

Excel Workbook
	A	B	C	D	E	F	G
1	TV	Newspaper	Publications/Magazines	Radio	Consumer direct mail	Billboards/ Signage	New Formula Here
2	80,796						#VALUE!
3		11,995					#VALUE!
4			17,951				#VALUE!
5						800	#VALUE!
Sheet1

Excel 2007

Cell Formulas
Range	Formula
G2	=--(ReportSource!$I$340:$I$7986="TV")
G3	=--(ReportSource!$I$340:$I$7986="Newspaper")
G4	=--(ReportSource!$I$340:$I$7986="Publications/Magazines")
G5	=--(ReportSource!$I$340:$I$7986="Billboards/Signage")

 

[shift-del]

Hello Jim

Something like this?

=--(ReportSource!$I$340:$I$7986=LOOKUP(9^99,A2:F2,A$1:F$1))

 

[jim may]

Thanks Shift-del; Got it working!!

Jim