i have several vlookups in sheet 2, that is taking data from sheet 1.

it works perfectly when i need to see the data i am after, but sometimes i need the cell to be blank when i do not require it to look up information.

the formula that im using is
=VLOOKUP(C5,STOCK2,2,FALSE)

when C5 is blank, this cell shows up as #N/A.

how do i make this cell blank if cell C5 is blank?

any suggestions?