I am using an IF function in my worksheet to check if the cell contains "#N/A" (this value is got by using the VLOOKUP function).
Using the IF condition as follows:
CellA1 - "Some Text"
CellB1 - "#N/A" (got when vlookup was unsuccessful)
CellC1 - =IF(A1<>"#N/A", A1&" "&B2, A1)
so in this case if cellB1 contains some other text eg. "some other text" then cell C1 would display "Some Text some other text" ie it concatenates text from cell A1 and B1. If it has "#N/A" in cell B1 then cell C1 should display "Some Text".
But in this case it display "#N/A".
Can anyone know why? I am quite sure the IF formula is correct.
Using the IF condition as follows:
CellA1 - "Some Text"
CellB1 - "#N/A" (got when vlookup was unsuccessful)
CellC1 - =IF(A1<>"#N/A", A1&" "&B2, A1)
so in this case if cellB1 contains some other text eg. "some other text" then cell C1 would display "Some Text some other text" ie it concatenates text from cell A1 and B1. If it has "#N/A" in cell B1 then cell C1 should display "Some Text".
But in this case it display "#N/A".
Can anyone know why? I am quite sure the IF formula is correct.