vlookup in two or more columns

[Jocote46]

Hello everyone,

I need your help. Im trying to create a formula that where the user will have 2 options:

1- enter sku number
2- enter barcode

desire results:

1. product description
2. product cost
3. product retail price

I was able to get this information to work using only one option but I'm stuck. I can't seem to find a way to get the desire results to work using both search fields. it works when i enter the sku number but if sku number is blank then I get nothing.

this is a small sample of database (see attached xls.file)

would really appreciate your help with this.
P.S. i want the user to have the option to use sku or barcode and get same information

Thanks in advance.