Forum Discussion
Solved
formula help
HI there Need help adding more information to the formula I am using vlookup but i want to added another formula to it. I have #N/A from the vlookup and when there is #N/A in it, i want to be able ...
- Add an "@" before your lookup value =IFERROR(VLOOKUP(@A:A,'RAW DATA'!C:H,6,FALSE), 0). This will only work if the cell you are looking up is in the same row as this formula. Either that or reference a specific cell =IFERROR(VLOOKUP(A16,'RAW DATA'!C:H,6,FALSE), 0). YOu are getting the Spill error because it's trying to look up the whole column
Thank you very much that work perfect
Currently this formula will change #N/A to 0
=IFERROR(VLOOKUP(A16,'RAW DATA'!C:H,6,FALSE), 0)
If you want to change it to something else you could do the following
=IFERROR(VLOOKUP(A16,'RAW DATA'!C:H,6,FALSE), "Previous Balance Forward") now it will change it the text "Previous Balance Forward", you can also have it reference a cell
=IFERROR(VLOOKUP(A16,'RAW DATA'!C:H,6,FALSE), 0)
If you want to change it to something else you could do the following
=IFERROR(VLOOKUP(A16,'RAW DATA'!C:H,6,FALSE), "Previous Balance Forward") now it will change it the text "Previous Balance Forward", you can also have it reference a cell