VLOOKUP from formula

[dandanfielding]

Is there an issue with VLOOKUP where the lookup value is the result of a formula? I am getting #N/A error on this formula: =VLOOKUP(B12,Tables!P2:Q35,2,FALSE). The formula in cell B12 is =ROUND((D6+D8)/2,0). I found other threads that recommended I confirm that B12 is formatted as a number, and it is. Just in case, I tried one of the fixes I saw, adding a +0 to the formula to make it look like this: =VLOOKUP(B12+0,Tables!P2:Q35,2,FALSE). So far I have been unable to resolve this error. Any ideas?

 

[Fluff]

Are the values in col P also numbers rounded to 0 decimal places?

 

[dandanfielding]

Are the values in col P also numbers rounded to 0 decimal places?

Great catch, they were not! I imported data from another source and didn't check the formatting. I have egg on my face, such a simple solution! Thank you!

 

[Fluff]

Glad to help & thanks for the feedback.