Vlookup

[petermccallion]

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

 

[Fluff]

Hi & welcome to MrExcel.
This formula

='IQA Tracking'!N18 &""

is converting the value into text, why not keep it as a number like

='IQA Tracking'!N18

 

[petermccallion]

Works thanks you

 

[Fluff]

You're welcome & thanks for the feedback.