petermccallion
New Member
- Joined
- Mar 22, 2012
- Messages
- 11
I have a formula =IF(C5=0,"",VLOOKUP(C5,'Summative Tracking'!$F$18:$CT$18,12,FALSE)) and it returns the error #N/A.
the formula requires the value of C5 to be found from the array is the error code because the Value of C5 is a number but in the array C5 is the result of a formula i.e. ='IQA Tracking'!N18 &""
both c5 and f18 contain the same number i.e. 12345 for example
the formula requires the value of C5 to be found from the array is the error code because the Value of C5 is a number but in the array C5 is the result of a formula i.e. ='IQA Tracking'!N18 &""
both c5 and f18 contain the same number i.e. 12345 for example