Hi,
I have creadted a VLOOKUP function which is working perfectly:
=VLOOKUP(A53,Report!$A$2:$B$200,2,FALSE)
However when it does not find a match it returns the value #N/A which is normal. I would like to change it so that it does not return a value at all, or returns a value i specify. Can this be done? I was thinking of creating an IF statement to fix this, but i dont know if you can have multiple formulas (VLOOKUP & IF) within the same cell...
Can anyone help?
I have creadted a VLOOKUP function which is working perfectly:
=VLOOKUP(A53,Report!$A$2:$B$200,2,FALSE)
However when it does not find a match it returns the value #N/A which is normal. I would like to change it so that it does not return a value at all, or returns a value i specify. Can this be done? I was thinking of creating an IF statement to fix this, but i dont know if you can have multiple formulas (VLOOKUP & IF) within the same cell...
Can anyone help?