I'm facing a unique situation. I have a table with two columns - GM% and Payout%. While applying Vlookup on a value that's been derived by an average of three equal numbers, I'm getting #N/A even though when I use vlookup on the individual numbers, I get perfect results. Any idea what I'm doing wrong?

CodePudding user response：

You have to round the result of the AVERAGE to the precision of your base data (GM%):

= ROUND(AVERAGE(F2:H2),2)