DonovanNeb
New Member
 Joined
 Jan 4, 2021
 Messages
 3
 Office Version

 2013
 2007
 Platform

 Windows
Microsoft Office Professional 2013
Windows 7 Enterprise
I'm trying to average multiple columns of values, based on a VLOOKUP for all columns, but coming across errors when one of thsoe columns values is #N/A.
Here is my formula : =AVERAGE(VLOOKUP($S2,$A:$E,2,FALSE),VLOOKUP($S2,$H:$K,2,FALSE),VLOOKUP($S2,$M:$Q,2,FALSE))
First VLOOKUP($S2,$A:$E,2,FALSE) = 11
Second VLOOKUP($S2,$H:$K,2,FALSE) = 14
Third VLOOKUP($S2,$M:$Q,2,FALSE) = #N/A or doesn't exist
I've tried IFNA, but it replaces the #N/A with "" and that gives me a #VALUE, I'm assuming because "" is a character amongst numbers. I'd like to find an answer within 1 statement or command like above.
Thanks, Donovan
Windows 7 Enterprise
I'm trying to average multiple columns of values, based on a VLOOKUP for all columns, but coming across errors when one of thsoe columns values is #N/A.
Here is my formula : =AVERAGE(VLOOKUP($S2,$A:$E,2,FALSE),VLOOKUP($S2,$H:$K,2,FALSE),VLOOKUP($S2,$M:$Q,2,FALSE))
First VLOOKUP($S2,$A:$E,2,FALSE) = 11
Second VLOOKUP($S2,$H:$K,2,FALSE) = 14
Third VLOOKUP($S2,$M:$Q,2,FALSE) = #N/A or doesn't exist
I've tried IFNA, but it replaces the #N/A with "" and that gives me a #VALUE, I'm assuming because "" is a character amongst numbers. I'd like to find an answer within 1 statement or command like above.
Thanks, Donovan