Forum Discussion
Need help getting rid of #N/A in my formula; please help
'=IF($AB$4='8B-Saginaw'!$C$9,VLOOKUP('Adjusted Inventory Summary'!F7,'8B-Saginaw'!$A:$F,6,0)). I need to return a zero or blank.
Neither of those worked
The #N/A error suggests that the lookup_value is not located in the table_array. However, without a sample file, it would be impossible to confirm this suspicion.