VLookUp

[Bob]

The following formula works ok, except when a cell in Col
C is empty the formula returns N/A (understandably).
How can I adjust the formula so that the cells in Col B
stay blank until a value is put in Col C.

=VLOOKUP($C2,FinalBudget!A2:B26,2,FALSE
Any help would be welcomed.
Regards
Bob

 

[Andy B]

Bob

Enclose your formula in an IF function:
=IF($C2<>"",VLOOKUP($C2,FinalBudget!A2:B26,2,FALSE),"")

Andy.

 

[Bob]

Andy
that's great! Thanks very much.
Bob

-----Original Message-----
Bob

Enclose your formula in an IF function:
=IF($C2<>"",VLOOKUP($C2,FinalBudget!A2:B26,2,FALSE),"")

Andy.




.