I just posted but the thread seems to be missing mysteriously.

i really need help in this and its pretty urgent, hope ppl here can help me with it

i have this formula

=IF(ISERROR(VLOOKUP($C7,'Sheet B'!$B$2:$D$176,3,FALSE)),"",VLOOKUP(C7,'Sheet B'!$B$2:$D$176,3,FALSE))

and i would like to add an extra condition such that when D7 is filled by a number, there would be a reading

if D7 is unfilled, there would be no reading at all


can anyone comment on this?