Forum Discussion

Copper Contributor

Mar 23, 2022

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 ...

community

Dbstedman
Mar 28, 2022
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

Southpaw19

Copper Contributor

Mar 28, 2022

Thank you very much
=IFERROR(VLOOKUP(A:A,'RAW DATA'!C:H,6,FALSE), 0) using this formula on another column but i am getting #spill! error not sure why thou. I am learning the formulas 🙂

Dbstedman

Brass Contributor

Mar 28, 2022

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

Southpaw19
Copper Contributor
Mar 28, 2022
Thank you very much that work perfect
- Dbstedman
  Brass Contributor
  Mar 28, 2022
  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