Hi,

I am creating 1 spreadsheet from 2 moving sheets using Vlookups. However not
all sheets have the same things to look up and returns #n/a - I can change to
use isna, but if I use for all cells I get False where their would be a value
without the isna.

Can anyone help to give 1 formula ?

=VLOOKUP($B:$B,'Current Forecast'!$C:$S,4,FALSE)+VLOOKUP($B:$B,'Current
Forecast'!$C:$S,4,FALSE)

=IF(ISNA(VLOOKUP($B:$B,'Current
Forecast'!$C:$S,4,FALSE)),0)+IF(ISNA(VLOOKUP($B:$B ,'Current
Forecast'!$C:$S,4,FALSE)),0)

Many thanks for any advice!