Vlookup value is returning N/A when referencing a cell with sum formula in

[matthewoaks]

Hi All,
I have a simple lookup formula; in cell N7 I have the below

=IFNA(VLOOKUP(C7,'1SV'!A1:B731,2,FALSE,"")

The user manually enters a value in C7 and N7 returns the correct value

I now need to have a formula in C7
=SUM(A7+B7+D7) as an example and it still return the value like before in N7 but it's not working.
The cell returns N/A

Am I missing something in my vlookup formula? Both table and lookup cell is formatted to number at 3dp as it's showing the volume of a tank in m3

Any advice would be appreciated

 

[matthewoaks]

RoryA
I think I've just sussed it by using =Round(A+B+C,0) suggested by Peter earlier but rounding down to the whole number

Thanks for your help and guidance guys

 

[Peter_SSs]

Glad you got it sorted eventually.