#### matthewoaks

##### New Member

- Joined
- Jan 31, 2014

- Messages
- 30

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