VLookup

[Guest]

I want to generate a purchase order By using an easy VLOOKUP funktion to connect the Products with their Article number. The only problem is when there is no product typed in it shows the message #N/A which I do not want. Is there a way to avoid this message. I can not make it white because once a product is selected I want the text in black letters

Thank for your help

CU Matt

 

[Guest]

Matt,

Use an IF statement. Something like

=IF(ISBLANK(A1),"",VLOOKUP(A1,???,???))
where A1 would be the cell where the user inputs the product.

Hope this helps,
Ron_D