Need one more element to this formula

[RodneyW]

How do I modify this:

=IFERROR(VLOOKUP($A8,'D:\Corporate\Analytics\2019Analytics\Final2019\[NewsLettersJan2019.xlsx]Stations'!$A$3:$FC$156,64,FALSE),"")

so the result is multiplied by J6

thank you in advance

 

[Joe4]

J6 from the same sheet as where this formula is placed?

You will want to return 0 in the event of an error, not "" so you can do the math, i.e.

[COLOR=#000000][FONT=Calibri]=IFERROR(VLOOKUP($A8,'D:\Corporate\Analytics\2019Analytics\Final2019\[NewsLettersJan2019.xlsx]Stations'!$A$3:$FC$156,64,FALSE),0) * J6[/FONT][/COLOR]