Previous Topic Next Topic

Adding and subtracting using Vlookups

Closed
libseal Posts 1 Registration date Thursday 26 October 2017 Status Member Last seen 26 October 2017 - 26 Oct 2017 à 05:43
 Blocked Profile - 27 Oct 2017 à 17:13
Hello,

=IFERROR((E2)-(VLOOKUP($B:$B,'Forecast Pivot'!$A:$AB,3,FALSE))," ")

I need to add in another vlookup to the formula but have tried a few options and its not taking it - whats the solution please?

Thanks in advance

1 response

Réponse 1 / 1
Blocked Profile
27 Oct 2017 à 17:13
ok using this as an example:

=IFERROR((E2)-(VLOOKUP($B:$B,'Forecast Pivot'!$A:$AB,3,FALSE))," ")

We cannot help, as what are you expecting the result to be? Where does the extra VLOOKUP Go? Good question!

Similar discussions

Ig stories from close friends to public
Darren -
zara -

31 responses
Why does our account keep randomly following additional users every few weeks?
Coach -
ElenaKM -

1 response