Adding and subtracting using Vlookups [Closed]

Report
Posts
1
Registration date
Thursday October 26, 2017
Status
Member
Last seen
October 26, 2017
-
 Blocked Profile -
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 reply


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!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!