Forum Discussion

Southpaw19's avatar
Southpaw19
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's avatar
    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
Dbstedman's avatar
Dbstedman
Brass Contributor
Mar 23, 2022
If I am understanding your question correctly you could use =IFERROR(VLOOKUP(@A:A,'RAW DATA'!C:F,4,FALSE),"0"). If you wanted to add another formula for #N/A you could use =IFERROR(VLOOKUP(@A:A,'RAW DATA'!C:F,4,FALSE),IF(.........). If you get an error the formula then moves to the second IF function
Southpaw19's avatar
Southpaw19
Copper Contributor
Mar 28, 2022
=IFERROR(VLOOKUP(A:A,'RAW DATA'!C:H,6,FALSE),0) I used this formula and i am getting #splii! now
I used this same formula on different column and it work

Resources