Previous Topic Next Topic

Adding and subtracting using Vlookups

Closed
libseal Posts 1 Registration date Thursday October 26, 2017 Status Member Last seen October 26, 2017 - Updated on Oct 26, 2017 at 12:39 PM
 Blocked Profile - Oct 27, 2017 at 05:13 PM
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
Related:

1 response

Answer 1 / 1
Blocked Profile
Oct 27, 2017 at 05:13 PM
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!
0

Similar discussions

Ig stories from close friends to public
Darren -
zara -

31 responses
add/subtract & vlookup formula
sudhir -
sudhir -

2 responses
Formula to subtract one cell value from another.
autigers71 -
vcoolio -

1 response
Keyboard typing letters and numbers at the same time
Hottie -
Isebas -

37 responses