IF statements

[Chogger]

i'm currently designing an invoice for a local company. I have arranged stock codes and item names by way of look up. How ever if the "stock code" and "item" column are blank, N/A appears within the "item". How can i use IF staements to get around this?, i.e IF the stock code is blank nothing appears in the "item" column.
Any help is appreciated.
Chogger.

 

[Mark W.]

On 2002-04-23 14:20, Chogger wrote:
i'm currently designing an invoice for a local company. I have arranged stock codes and item names by way of look up. How ever if the "stock code" and "item" column are blank, N/A appears within the "item". How can i use IF staements to get around this?, i.e IF the stock code is blank nothing appears in the "item" column.
Any help is appreciated.
Chogger.

=IF(ISBLANK('Stock Code'),"",VLOOKUP(...))
This message was edited by Mark W. on 2002-04-23 14:24