Stringing together vlookups

[Brendan]

Im not sure if Im using the right function here.

But I have 3 columns for products, at any given time, 0 to 3 of these columns may have data in them.
Im wanting relate each product to a price.

If I dont enter all 3 colums though it returns with a #N/A error.
If only one product is sold, I want it to return with just the one product price.

Any help?

 

[Brendan]

so 0 = blank.

I came to a similar conclusion by entering a 'null' column which returned 0.