Formula not showing correct answer.

[JaysonHughes]

Formula not showing correct,

=VLOOKUP(F6,F:G,2,0)+VLOOKUP(F6,F:H,3,0)/VLOOKUP(F6,F:I,4,0)+VLOOKUP(F6,F:J,5,0) not showing correct result =(((G2+H2)/(I2+J2))) Showing correct result Any advice would be great

 

[JaysonHughes]

wrong data set
Above

=VLOOKUP(A6,A:F,2,0)+VLOOKUP(A6,A:F,3,0)/VLOOKUP(A6,A:F,4,0)+VLOOKUP(A6,A:F,5,0) not showing correct result =(((B2+C2)/(D2+E2))) Showing correct result Any advice would be great

 

[petertenthije]

You’ll need some more brackets.

=(VLOOKUP(A6,A:F,2,0)+VLOOKUP(A6,A:F,3,0))/(VLOOKUP(A6,A:F,4,0)+VLOOKUP(A6,A:F,5,0))

 

[JaysonHughes]

Legend

 

[JaysonHughes]

Where Would I Put a IFERROR statement ?

 

[JaysonHughes]

Found iT

 

[Fluff]

For future reference.

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: VLOOK UP Not giving correct answer.
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.