lisaspencer
New Member
- Joined
- Jul 20, 2020
- Messages
- 21
- Office Version
- 365
- Platform
- MacOS
I have quite a few VLOOKUP tables connected in 1 spreadsheet and it all works fine.
I have one column formula that is basically =columnS - columnN
So the VLOOKUP formula is =IFERROR((VLOOKUP($A1,Database,19,FALSE)-VLOOKUP($A1,Database,14,FALSE))," ")
In columnS (vlookup row 19) are numbers(percentages) and the same in columnN (vlookup row 14) and it works out the difference between the two
But sometimes there is the text "NA" in columnN (vlookup row 14) and I want it to be counted as a 0 but when it is currently text it doesn't count it in the formula.
There are some blanks in columnN (vlookup row 14) too which is why the IFERROR is in front of the formula as I don't want them counted.
Can anyone help with my formula?
I have one column formula that is basically =columnS - columnN
So the VLOOKUP formula is =IFERROR((VLOOKUP($A1,Database,19,FALSE)-VLOOKUP($A1,Database,14,FALSE))," ")
In columnS (vlookup row 19) are numbers(percentages) and the same in columnN (vlookup row 14) and it works out the difference between the two
But sometimes there is the text "NA" in columnN (vlookup row 14) and I want it to be counted as a 0 but when it is currently text it doesn't count it in the formula.
There are some blanks in columnN (vlookup row 14) too which is why the IFERROR is in front of the formula as I don't want them counted.
Can anyone help with my formula?