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
Starrysky1988's avatar
Starrysky1988
Iron Contributor
Mar 23, 2022
I guess below is what you want.
=IFNA(VLOOKUP(@A:A,'RAW DATA'!C:F,4,0),0)
or
=IFNA(VLOOKUP(@A:A,'RAW DATA'!C:F,4,0),IF(B8<0,"CLAWBACK","FILL IN LATER") &" 0")

Resources